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.