I have a date field for the date of the last exam done, its a drop down calendar. All I want is to work out is, if more than 1 year has passed since that date then do something else do nothing.
if ( get(currentDate) > exam date + 365 )?
send mail to alert someone
else do nothing
Also how would you set this up so it only sends 1 email. I would want it to check each day(schedule run on filemaker server?) But if its more than 365 days I wouldn't want to send an email for every day after 1 year.