Simple Date Calculation

[KatieO]

I have a date field called "Expiration date." I want to add a selection criteria that would select all those with an Expiration date greater than or equal to 90 days prior to the Current Date.

Thanks!

 

[paulmarr]

Katie,

If you are a CryRpt instructor- you should know this one.

In the selection expert, select the Expiration Date field and choose 'formula' from the drop down box. Copy the following formula: {Expiration_date} >= CurrentDate - 90

Cheers,

paulmarr@arcom.com.au