AnsweredAssumed Answered

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

Question asked by DJD on Nov 4, 2009
Latest reply on Nov 4, 2009 by philmodjunk

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.

Outcomes