last year data

[Former Member]

Good Day to All,

I have a sub-report that i only want to print when the data is within a year of the print date.

So say I'm printing today which is 03/22/2013.

I want all transaction that fall in between  03/22/2012 through 03/22/2013.

I tried using the YearToDate but I was only getting this year information

date({Command.udate}) in YearToDate

Kind Regards,

David M

[former_member203168 · Accepted solution]

Hi David,

Try the below formula

date({Command.udate}) in [Date({Command.udate}) To Dateserial(year(date({Command.udate}))-1,month(date({Command.udate})),day(date({Command.udate})))]

--Praveen G

[abhilash_kumar · Accepted solution]

Hi David,

Here's the formula that works. Use it in the Record Selection formula:

{Command.udate} in [cdate(year(currentdate)-1, month(currentdate),day(currentdate)) to currentdate]

Hope this helps!

-Abhilash

[Former Member · Accepted solution]

Thanks Abhilash works perfectly.

[abhilash_kumar · Accepted solution]

Glad it works David!

Please don't forget to close the thread.

-Abhilash

[Former Member · Accepted solution]

OK