1 Reply Latest reply on Mar 22, 2015 3:08 PM by philmodjunk

    date search problem

    LouisFoster

      Title

      date search problem

      Post

      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