Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Constantly update a date field with the current date

Topic Labels: Automations
1049 1
cancel
Showing results for 
Search instead for 
Did you mean: 
MeetMax_Concier
4 - Data Explorer
4 - Data Explorer

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 1
Sho
11 - Venus
11 - Venus

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")