search for 6 months either side of a date
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