March 4, 200619 yr 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
March 4, 200619 yr 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
Create an account or sign in to comment