Skip to main content

UPDATE 2: last modified time is now available to everyone! You can learn more about it here.

UPDATE: The last modified time beta is now closed as we get ready for a general release. Thanks to all of the testers who made this beta a success.

ORIGINAL POST:

Hi folks! We’re very excited to announce that we’re beta testing a last modified time field type, as well as a LAST_MODIFIED_TIME formula function. Many thanks to the users who’ve posted specific, detailed feedback about their needs and use cases with regard to this feature, like @Arlo_Haskell, @Deborah_Buck, and @Jordan_Friedman. We read everything that is posted here in the forums and your feedback is incredibly valuable for us when we’re planning the product roadmap and developing new features!

If you’re a Pro plan user and you’re interested in testing out the last modified time field type and/or the LAST_MODIFIED_TIME formula function—and giving us your feedback—please sign up using this form. (Note: this is a different form from our standard beta signup form, and it requires you to fill out a couple of additional questions.)

As you are all aware, this is a highly anticipated feature, and there are many users who would like to get beta access. However, for technical reasons and to ensure an optimal user experience, rollout for this beta will be conducted in small, limited batches. (In practical terms, that means that it might take a while for you to get access.)

+1 on modified timestamp!


+1 surely a must-have!

+1 on a modified timestamp here too

me too! please add a modified timestamp!!!

I like the alternative: CREATED_TIME(). Is there a way to format the date?

Currently it appears like this: 2016-11-04T16:18:39.000Z


I would like it to appear as: 11/4/2016 4:18pm

I would love to see the following time-stamps. ETA on this?


created time

last modified time

created by user


Thanks!

This is definitely keeping me from investing much time into Airtable.

+1 for a last modified formula!!!

I too would like to have a formula for last modified please!

+1 to last modified timestamps. Please!

I would use “last modified” to organize tasks and measure how long they took to get done

Agreed. Not using the service because it is lacking this functionality.

another +1 for auto “created date” and “modified date”! Couldn’t the created date just be the date field with an option for default?

Hi Stuart.


No, we don’t have a modified timestamp… yet.


~ Tim


How can I control the timezone of the create date timestamp? It’s about 5 hours ahead of me…

Thanks.

I’d love their to be a way to automatically add the date created to a field. And yes date modified would help too. Thanks!

+1. This is a blocking issue for the future use of Airtable for us

I’d love their to be a way to automatically add the date created to a field. And yes date modified would help too. Thanks!


Kerry,


Actually, we do have a way to get a record’s “date created” value now. You can create a Formula Field and set it’s formula to: CREATED_TIME()


I hope that helps.


Tim

How can I control the timezone of the create date timestamp? It’s about 5 hours ahead of me…

Thanks.


OK if there’s anybody out there. Answer is TIMEZONE. My case:

DATETIME_FORMAT(SET_TIMEZONE(CREATED_TIME(), ‘America/New_York’), ‘M/DD/YYYY h:mm A’)

Results in:

1/17/2017 11:30 AM

Any timeline on providing modified time? it would be very helpful and a key ability for the task-tracking table I want to create. (and would get me parity with my current google spreadsheet macro).

+1 for this too. Additionally a “modified by” feature addition as well.

Kerry,


Actually, we do have a way to get a record’s “date created” value now. You can create a Formula Field and set it’s formula to: CREATED_TIME()


I hope that helps.


Tim


Thanks Tim,

How do I make a proper formula that includes my timezone preference?

This does not work:

CREATED_TIME() SET_TIMEZONE(datetime, ‘America/Los_Angeles’)

Kerry

Thanks Tim,

How do I make a proper formula that includes my timezone preference?

This does not work:

CREATED_TIME() SET_TIMEZONE(datetime, ‘America/Los_Angeles’)

Kerry


You would want to wrap the two functions, like this:


SET_TIMEZONE(CREATED_TIME(), ‘America/Los_Angeles’)


However, that doesn’t seem to be returning the correct time when I test it.

Thanks Tim,

How do I make a proper formula that includes my timezone preference?

This does not work:

CREATED_TIME() SET_TIMEZONE(datetime, ‘America/Los_Angeles’)

Kerry


Hi Tim,

I tested

SET_TIMEZONE(CREATED_TIME(), ‘America/Los_Angeles’)

and indeed it does not set the timezone properly.

What do you suggest?

Thanks, Kerry

Hi Tim,

I tested

SET_TIMEZONE(CREATED_TIME(), ‘America/Los_Angeles’)

and indeed it does not set the timezone properly.

What do you suggest?

Thanks, Kerry


Hi Kerry,


In order to get your formula to work, you’ll need to include the DATETIME_FORMAT function in addition to the SET_TIMEZONE function, so, e.g.:


DATETIME_FORMAT(SET_TIMEZONE(CREATED_TIME(), ‘America/Los_Angeles’), ‘M/D/YYYY h:mm a’)


You can specify the output using the format specifiers listed in this support article. Hope this helps!

Hi Tim,

I tested

SET_TIMEZONE(CREATED_TIME(), ‘America/Los_Angeles’)

and indeed it does not set the timezone properly.

What do you suggest?

Thanks, Kerry


That worked, thank you!!!

Kerry

Reply


Terms & Conditions