fmchong
27th April 2009, 09:35
Hi,
I am facing a problem to get "todaydate" in my birt reporting. I want to have a filtering scenario in my report is "TODAYDATE -ReceiptDate" >=30.Any command to get TODAY DATE?
Please advise.
Thank you.
rameshchinnap
28th April 2009, 14:17
for birt use newdate() to get current date
fmchong
29th April 2009, 04:29
Hi,
Thank you for reply. I tried it out but prompt me the error as per attached.
Thank you.
rameshchinnap
29th April 2009, 08:15
that should be " new Date() " not newDate()
Note: there should be space between "new" and "Date "
fmchong
4th May 2009, 06:04
Hi,
I tried to use this command but prompt me error.
Please advise.
Thank you.
rameshchinnap
4th May 2009, 12:05
if you want the difference between two dates in number of days,
for your case you need difference between two dates one is ReceiptDate and second one is today date and that should be greater than or equal to 30 (days)
so use below filter condition
DateTimeSpan.days(row["RECEIPTDATE"],new Date())
Note: I have attached "screen shots" document for your reference where i have showed you two solution follow which one you like most
fmchong
8th May 2009, 12:27
Hi,
It can work :) many many thanks to you!