How do I show 2 years to date?

[nervous2]

I have a report with dates and using the select expert feature I able to select year to date or various other date structures but I want to display 2 years to todays date any idea how to write this formula?

Your help is appreciated.
Thanks

 

[kskid]

How about

(
{table.date} in YearToDate or
{table.date} in LastYearYTD
)

-lw

 

[nervous2]

thanks for the reply but it looks like this formula is for Year to Date, I'm looking for 2 years to current date.

Thanks

 

[CrystalLion]

Simplest way is to create two parameters: BeginDate and EndDate

Add the parameters to your Selection Expert, select statement

{file.tran_date} >= {?Pm-?BeginDate} and
{file.tran_date} <={?Pm-?EndDate}

 

[lbass]

Please do not crosspost. I answered in another forum.

-LB

 

[nervous2]

I could do that but then i would need to edit the report frequently, to show "2 years worth of data" this report will be run daily and will need to be current.

 

[dgillz]

How about:

Date(Year(CurrentDate)-2,1,1) to CurrentDate

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?