|Trying to create a report variable that returns yesterday's date in yyyy-MM-dd format [message #756986]
||Tue, 15 November 2011 15:35
Registered: November 2011
I am new to this and I am trying to create a variable on a report that will return yesterday's date formatted yyyy-MM-dd and have had no luck. Any help would be appreciated. I have tried |
BirtDateTime.year(BirtDateTime.now()) + "-" + BirtDateTime.month((BirtDateTime.now()) + "-" BirtDateTime.day(BirtDateTime.now())
and it will return today's date in the required format, but I can't get it to pull yesterday (and it doesn't seem like the correct way to get this to work).
The reason I am looking for a variable is so that I can use it in a number of filters for the report that all require yesterdays date in that format.
Powered by FUDForum
. Page generated in 0.01905 seconds