gvamsimba
asked on
SSRS Date formatting
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(dateinterva l.Year,20, Fields!AccreditationDate.V alue),"dd/ MM/yyyy")
Thanks
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(dateinterva
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
Select Number Tab and select format as date and also choose options as you like (DD/MM/YY, MM-DD-YYYY etc. etc.)