AnsweredAssumed Answered

search for 6 months either side of a date

Question asked by clairebushell on May 16, 2012
Latest reply on May 17, 2012 by GuyStevens

Title

search for 6 months either side of a date

Post

i have a feild contract expiry date and i want to write a script to search for records eipiry 6 months before or after the current (todays) date. how do i do this? 

 

then ideally i want to generate an email alert when a contract exiry date in with in 6 months of the current date and the email be sent once a month automatically - can that be done??

i'm using Filemaker 12 but am quite new to it. 

thanks in advance 

Outcomes