Syed Shareef Ahmed
asked on
datediff of ssrs
I have date in number data type, I am using expression as attached.
It shows #Error in the report, I have attached a screen shot of the report which shows #Error in 'Days' column marked with Red Box.
Please guide me if i am wrong.
datediff.jpg
datedifferr.jpg
It shows #Error in the report, I have attached a screen shot of the report which shows #Error in 'Days' column marked with Red Box.
Please guide me if i am wrong.
datediff.jpg
datedifferr.jpg
ASKER
Hi,
Thanks for suggestion, when I change the expression I receive any error, please find attached of screen shots.
datediff-exp-1.jpg
datedifferr-1.jpg
Thanks for suggestion, when I change the expression I receive any error, please find attached of screen shots.
datediff-exp-1.jpg
datedifferr-1.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
https://msdn.microsoft.com/en-us/library/microsoft.visualbasic.dateinterval%28v=vs.110%29.aspx
I've had good success using the members of that class whenever SSRS is looking for an interval in a date function.
Remember not to use quotes around DateInterval.Day.