AnsweredAssumed Answered

Automatic Updating of Dated Records

Question asked by PWGKing on Jan 19, 2010
Latest reply on Jan 19, 2010 by PWGKing


Automatic Updating of Dated Records


I'm using FMP Adv 10. I have the following fields that do not udate each day when the database is opened for the first time. Get(CurrentDate) does not work for this required process.


Date Inspection Due:    21/04/2010

Days Until Due:                      93


Can someone help with a date calculation that will:


1) Calculate Todays date minus "Date Inspection Due" = "Days Until Due"

2) Calculation to Update ALL records upon initial opening of database each day.


Any assistance would be greatly appreciated.