Link to home
Start Free TrialLog in
Avatar of chrisryhal
chrisryhal

asked on

Format Date Expression in SSRS

I need to be able to create an expression that takes today's date =FormatDateTime(Today()) and format it like 23-OCT-08 minus 1

So the value would actually be 22-OCT-08
Avatar of jgv
jgv
This should do it
=Format(Date.Today.AddDays(-1), "dd-MMM-yy")
Avatar of chrisryhal
chrisryhal

ASKER

says that AddDays is an unrecognized identifier
ASKER CERTIFIED SOLUTION
Avatar of jgv
jgv
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 chrisryhal
chrisryhal

ASKER

Actually, I got it to work after messing with what you originally gave me:

=Format(Today().AddDays(-1), "dd-MMM-yy")

Thanks for the tip and the crutch to get me here :)