Find Future Date

[WBlanchard]

Yes, do a find on a date range. Enter find mode on a layout the contains the maintenance expire date and enter into that field (for the next 3 months 10/12/2000...1/12/2001. This should find all records that will expire in the next 3 months.

HTH

[jimpres]

I think this is simple, except for me.

I have 375 records in a file.

There is a date field called 'maintenance'.

I want to find all records for which the date will expire within the next three months. Then I want to automatically send each expiring 'maintenance' an E-mail for them to renew there 'maintenance'

Thanks,