troubleshooting Question

Lookup date field with only year, day and month in SSRS

Avatar of gosi75
gosi75Flag for Iceland asked on
SSRSMicrosoft SharePointMicrosoft SQL Server
1 Comment1 Solution1412 ViewsLast Modified:
I'm trying to write an expression where i need to lookup a date value from another sharepoint list. It works well when I only wants to get the value, but when I try to use some date function, like day,month or year I get this error:
The Value expression for the textrun 'Textbox7.Paragraphs[0].TextRuns[2]' has an incorrect number of parameters for the function 'Lookup'.

This is the expression I was using test it,  with the above error message:
=Lookup(Fields!cth_VMID.Value,Fields!cth_VMID.Value,Year(Fields!cth_Date.Value, "Datasetb"))
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros