AnsweredAssumed Answered

date search problem

Question asked by LouisFoster on Mar 22, 2015
Latest reply on Mar 22, 2015 by philmodjunk


date search problem


Hello all.

I am new to filemaker and loving it, but I have a little problem that I am trying to work through. I have a table called training that is used to store the type of training, the training date, how long the training is good for, and the last field is a calculation  of TrainingDate + (training is good for * 365).

Calculation field works great, the problem I am having is I would like to have a script that runs when the database is opened that will check all the Next training due dates and show an alert when training is 90 days from expiration. 

Thank You,

Louis Foster

Any help on the problem will be greatly appreciated