Skip to main content

Last modified time [SOLVED]

  • May 21, 2015
  • 218 replies
  • 750 views

Show first post

218 replies

  • New Participant
  • October 18, 2016

+1 on modified timestamp!


  • New Participant
  • October 20, 2016

+1 surely a must-have!


+1 on a modified timestamp here too


  • New Participant
  • November 4, 2016

me too! please add a modified timestamp!!!


  • New Participant
  • November 8, 2016

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


  • New Participant
  • November 8, 2016

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

created time
last modified time
created by user

Thanks!


  • New Participant
  • November 22, 2016

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


  • New Participant
  • November 23, 2016

+1 for a last modified formula!!!


  • New Participant
  • December 2, 2016

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


  • New Participant
  • December 13, 2016

+1 to last modified timestamps. Please!


Forum|alt.badge.img+4
  • Known Participant
  • December 23, 2016

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


  • New Participant
  • December 23, 2016

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


Forum|alt.badge.img+3
  • Participating Frequently
  • January 5, 2017

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


  • Known Participant
  • January 9, 2017

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.


Forum|alt.badge.img+8
  • Known Participant
  • January 15, 2017

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!


  • New Participant
  • January 16, 2017

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


Forum|alt.badge.img+4
  • Known Participant
  • January 16, 2017

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


  • Known Participant
  • January 17, 2017

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


  • New Participant
  • January 19, 2017

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.


Forum|alt.badge.img+8
  • Known Participant
  • January 26, 2017

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


Forum|alt.badge.img+4
  • Known Participant
  • January 26, 2017

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.


Forum|alt.badge.img+8
  • Known Participant
  • January 26, 2017

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


Forum|alt.badge.img+5
  • Author
  • Inspiring
  • January 26, 2017

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!


Forum|alt.badge.img+8
  • Known Participant
  • January 26, 2017

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