AnsweredAssumed Answered

Reminder and overdue date alert.

Question asked by LadyBear on Aug 7, 2012
Latest reply on Aug 10, 2012 by taylorsharpe

Hi,

 

I am still using filemaker 10 and I would love to be able to pick up when I need to send a reminder to clients to provide me with their updated insurance information or when it is overdue.

 

The only field I have is the expiry date of their insurance.

 

My idea is calculate the difference between the current date and the expiry date of their insurance. If this date < or equal to one month prior to the expiry date I would like to send the client a reminder. If the expiry date is overdue I would like an alert in filemaker.

 

I would like to do something similar for annual payments.

 

I haven't dealt with a whole lot of date functions at this stage.

 

Many thanks for your assistance.

Outcomes