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

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

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

Tue, 15 November 2011 15:35

Eclipse User

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

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

Tue, 15 November 2011 16:18

Eclipse User

I found a solution
Formatter.format(BirtDateTime.addDay(BirtDateTime.today(),-1), "YYYY-MM-dd")

Previous Topic:	Encoding a report design in another xml?
Next Topic:	birt chart accessibility options

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 22 21:15:58 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter