3 Replies Latest reply on Nov 4, 2009 1:22 PM by philmodjunk

    What is the correct way to get a real-time system date update on a calculation field?

    DJD

      Title

      What is the correct way to get a real-time system date update on a calculation field?

      Post

      I am new to FMPro Ver.10 and I am trying to make sure that I am getting a real-time system date update on a calculation field with the following formula:

       

      Remaining_Term = If(Liability_Date < Get(CurrentDate), 0, (Liability_Date - Get(CurrentDate))/365)

       

      I want the Remaining_Term field to continuely update off of the system date without updating or modifying any other fields.  Is it correct to use the Get(CurrentDate) function or should I be using something else?  Coming from using FMPro V.5 I would use the "Today" function, but in FMPro V.10 it doesn't have the "Today" function anymore.

       

      Any help on this is greatly appreciated.