Skip to main content

Time difference formula and field update time

  • July 17, 2023
  • 2 replies
  • 111 views
H
Forum|alt.badge.img+4
  • Herege
  • Participating Frequently

Hello guys,

I have a field that use a simple formula to calculate the time passed (in minutes) between the created time of a record and Now that goes like this:

 

DATETIME_DIFF(
  {Created},
  NOW(),
  'minutes') * -1
 
The time displayed in minutes on the field does not update every minute.
If can go from 1 minute, to 5 and then to 8 or 9.
 
My question is:
How can I have this field value update by the minute of even in seconds if the formula shows the time in second?
 
Hope I explain my self correctly 🙂
 
Thanks in advanced

2 replies

BillH
Forum|alt.badge.img+24
  • BillH
  • Brainy
  • July 17, 2023

I don't believe it is possible. 

From the NOW() documentation in the "Formula Playground"

"While similar to the TODAY() function, NOW() returns the current date AND time. This function updates when the formula is recalculated, when a base is loaded, or otherwise roughly every 15 minutes when a base is open. If the base is closed, it will update approximately every hour only when the base has time-dependent automation triggers or actions, or sync dependencies."

H
Forum|alt.badge.img+4
  • Herege
  • Author
  • Participating Frequently
  • July 19, 2023

I don't believe it is possible. 

From the NOW() documentation in the "Formula Playground"

"While similar to the TODAY() function, NOW() returns the current date AND time. This function updates when the formula is recalculated, when a base is loaded, or otherwise roughly every 15 minutes when a base is open. If the base is closed, it will update approximately every hour only when the base has time-dependent automation triggers or actions, or sync dependencies."


Yes, probably you're right.

Anyeay, thanks for the reply 😊

Terms & ConditionsAccessibility statement