Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Constantly update a date field with the current date

Topic Labels: Automations
223 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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