Determining 90 days prior to a specific day

[otiswade]

My database contains: TrainDate and ExpireDate. I need a report that details personnel that are within 90 days of their expiration date.

 

[dgillz]

You did not define what would make someone within 90 days of their expiration date. Do you mean the current date is within 90 days of the expiration date?


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

http://www.trianglepartners.com

 

[otiswade]

My apologies. Yes, current date is within 90 days of the individuals expiration date.

 

[dgillz]

to get all records where the exiration date in in the next 90 days, write a formula:

{Expiredate} in CurrentDate to Dateadd("d",90,Currentdate)

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

http://www.trianglepartners.com

 

[bdreed35]

Another approach would be to use the DateDiff function.

DateDiff("d", CurrentDate, {ExpireDate}) IN 0 to 90

~Brian