How do I limit data return to Current Year + previous 2 years?

[deborahyr]

Using Crystal XI, current database has data with multiple years, including future. How do I create a select records formula to only capture data in current year plus data from previous 2 years?

year(currentdate) - 2

 

[CR85user]

If you ran the report today, which of the following results would you want to see?

A)

1st Jan 2007 -> 1st April 2009

B)

1st Jan 2007 -> 31st March 2009

C)

1st April 2007 -> 1st April 2009

Or some other permutation?

'J

CR8.5 / CRXI - Discovering the impossible

 

[deborahyr]

I would expect to see results from "A". Thanks.

 

[CR85user]

{table.datadate} in date(year(currentdate)-2,month(currentdate),day(currentdate)) to currentdate

'J

CR8.5 / CRXI - Discovering the impossible

 

[CR85user]

Oops - Sorry just copy pasted the solution to C) by mistake - the info you need is:

{table.datadate} in date(year(currentdate)-2,01,01) to currentdate

Much simpler.

'J

CR8.5 / CRXI - Discovering the impossible