Alerts from a Date Field

[dcecil]

I need to keep track of software licenses and hardware warranties, but need to be alerted somehow when the current date reaches within 90 days of the expiration date field. Is this possible? If so, please describe in detail. I'm a fairly experienced user, but only moderately in the script area. I have managed, however to follow instructions to make pretty complicated scripts and calculations work.

Any help would be greatly appreciated.

Dave

[dkemme]

Make a calculated field, cExpiresSoon = case ( ExiprationDate - 90 < get (currentdate) ; "Expires Soon" ; "" ), make sure is text field and do not store result. Then create a script that goes to the layout, enter find mode, do not pause, set field cExpiresSoon, "Expires Soon", perform find, do not remember previous find. That should show you what you need to purchase.