HI Below is my date expression in ssrs.Basically it is giving
the date 20 years from the date of the field I specified.
If the field is todays date which is 15 sep 2011 then it is
returning 15 sep 2031. But I want to return 1 day less which
is 14 sep 2031.
Can any one re-write the expression for me ?
= format(dateadd(dateinterval.Year,20, Fields!AccreditationDate.Value),"dd/MM/yyyy")