Thursday, May 6, 2010

SSRS Dates Fun


SSRS 2005
If you want to set the parameter / textbox with Date to format ... You can try this.
=Format(Today(), "yyyyMMdd")

If you want to subtract (or add), you can try the below syntax
=Format(DateAdd("d", -1, Today()), "yyyyMMdd")
=Format(DateAdd(DateInterval.Day, -1, Today()), "yyyyMMdd")

MSFT did not provide full details ... but this one will helpful