Link to home
Start Free TrialLog in
Avatar of Subbu G
Subbu GFlag for United States of America

asked on

What is wrong with my SSRS Expression related to date calculation

Experts,   I have an Expression wrong.

         =DateAdd("d", (SUM(Fields!Duration.Value)+(Fields!InitialDuration.Value)), Fields!NoticeToProceed.Value)

Open in new window


What I want is I need to check if I have a dates in Notice to proceed [i.e, 1],
If yes then, I need to add integers in the section [2]+[3] to Notice to Proceed and populate it on [4]

if No then, populate NULL or empty  in [4] regardless of any value in other sections.

User generated image
Avatar of Subbu G
Subbu G
Flag of United States of America image

ASKER

=IIf(IsNothing(Fields!NoticeToProceed.Value),"", DateAdd("d", (SUM(Fields!Duration.Value)+(Fields!InitialDuration.Value)), Fields!NoticeToProceed.Value))

Open in new window

Avatar of Arifhusen Ansari
Do you want the date as a result or some integer value ?

I could not understand from your explanation
Avatar of Subbu G

ASKER

date
ASKER CERTIFIED SOLUTION
Avatar of Arifhusen Ansari
Arifhusen Ansari
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Subbu G

ASKER

I already fixed it Arif. Thanks for your reply though
Avatar of Subbu G

ASKER

=IIf(IsNothing(Fields!NoticeToProceed.Value),"", DateAdd("d", (SUM(Fields!Duration.Value)+(Fields!InitialDuration.Value)), Fields!NoticeToProceed.Value))