Eclipse Community Forums: BIRT » Trying to create a report variable that returns yesterday's date in yyyy-MM-dd format

Help

Home

Home » Archived » BIRT » Trying to create a report variable that returns yesterday's date in yyyy-MM-dd format

Show: Today's Messages :: Show Polls :: Message Navigator

Trying to create a report variable that returns yesterday's date in yyyy-MM-dd format [message #756986]

Tue, 15 November 2011 20:35

Todd

Messages: 4
Registered: November 2011

Junior Member

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.

thanks

Report message to a moderator