One year ago today 1

[vblack7770]

Crystal 8.5 with Oracle ODBC connection, XP.

I am trying to retrieve all records that meet the following criteria:

One year ago today
Example: 09/28/05 - I would like all records for 09/28/04.

(CurrentDate-365) doesn't seem to work.

 

[synapsevampire]

Since currentdate-365 would be incorrect on leap years, try:

dateserial(year(currentdate)-1,month(currentdate),day(currentdate))

You can also use:

Dateadd("yyyy",-1,currentdate)


So in the Report->Edit Selection Formula-Record, use:

{table.date} = dateserial(year(currentdate)-1,month(currentdate),day(currentdate))

-k