Record Selection Formula - Last 90 Days

[SSDDtoo]

I new to Crystal Reports. I have some knowledge of how to create reports that get the desired results - a novice but not a dummy!

My current challenge is: I need to push the record selection formula to the server that will return records from the date the report is refreshed back, 90 days. I've looked at the Record Selection Functions in the formula workshop and don't see anything that will handle that.

While I COULD get by with filtering AFTER bringing the values to the client, I'd prefer the server handle it.

Any suggestions?

 

[Madawc]

For Crystal 8.5, you can create a formula field that holds the date 90 days before the current, i.e.
DateAdd("d", -90, currentdate)

Then compare dates in the record selection

Madawc Williams
East Anglia, Great Britain

 

[Naith]

You don't need an additional formula or function.

{Date} > CurrentDate-90

in the Record Selection criteria is sufficient, and passes to the database.

Naith

 

[SSDDtoo]

Nadwac & Naith,

Thank you for your answers

Naith, your formula works!!!