AnsweredAssumed Answered

Date Calculation

Question asked by Ben_B94 on Apr 5, 2016
Latest reply on May 26, 2016 by Ben_B94

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.