Skip to main content

Constantly update a date field with the current date

  • March 17, 2022
  • 1 reply
  • 0 views

Hi gang, I feel like this must be easier than I think (but I don’t know anything about formulas, just automations, and barely those) but basically I’m trying to create a date field that will constantly update with today’s date. Ideas?

1 reply

Forum|alt.badge.img+19
  • Inspiring
  • 560 replies
  • March 18, 2022

How about use the Last Modified time field?
This is field that holds the last modification date of all fields or of a specific field.

Or, if you really only want to display the current date, use…

DATETIME_FORMAT(NOW(), "YYYYY/MM/DD")

Reply