Script Help with Current Date

[Wiz Bang Computers]

Could I please ask for some help with a script issue. I have a DB to hold copies of records like liability insurnace certificates for clients. These need to be updated on a regular basis. I would like to write a script to review the records and everyone with a Date of Next Update that is greater then current date plus 60 an email message is sent as a reminder.

This is what I am trying:

Show All Records

IF:

DATE OF NEXT UPDATE > (Get(CURRENT DATE)+ 60)

SEND EMAIL

END IF

This is not working for me. Any suggestions or help?

Thanks,

Scott

[RalphL]

Try:

Enter find mode with no pause

Set field [Date of next update; Get(CurrentDate) + 60]

perform find

Loop through these records sending your email