Subbu G
asked on
What is wrong with my SSRS Expression related to date calculation
Experts, I have an Expression wrong.
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.
=DateAdd("d", (SUM(Fields!Duration.Value)+(Fields!InitialDuration.Value)), Fields!NoticeToProceed.Value)
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.
Do you want the date as a result or some integer value ?
I could not understand from your explanation
I could not understand from your explanation
ASKER
date
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I already fixed it Arif. Thanks for your reply though
ASKER
=IIf(IsNothing(Fields!Noti ceToProcee d.Value)," ", DateAdd("d", (SUM(Fields!Duration.Value )+(Fields! InitialDur ation.Valu e)), Fields!NoticeToProceed.Val ue))
ASKER
Open in new window