I’ve seen a lot of wild posts about this topic, but I was wondering if there was a a more simple and concise explanation for how to convert a field containing an integer in Unix Time, to a Date field. The Airtable knowledge base has incorrect information: https://support.airtable.com/v1/docs/converting-unix-epoch-time-to-current-date?highlight=unix%20time
Solved
Convert UNIX time to Date Time
+10Best answer by ScottWorld
Wow, you’re right. That article is incorrect, and it also looks like Airtable has removed the full directory of formula functions that they used to have in their support articles.
Their once-unified support reference article on Date formulas has been broken up into a bunch of separate articles, many of which contain incomplete and/or inaccurate information.
In any case, the way to convert a UNIX timestamp into an actual date would be to use this formula:
DATETIME_PARSE( {Your Unix Timestamp Field}, 'x' )
And if your UNIX timestamp doesn’t contain milliseconds (i.e. it only goes up to seconds), you could use a capital letter X like this:
DATETIME_PARSE( {Your Unix Timestamp Field}, 'X' )
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
+33Wow, you’re right. That article is incorrect, and it also looks like Airtable has removed the full directory of formula functions that they used to have in their support articles.
Their once-unified support reference article on Date formulas has been broken up into a bunch of separate articles, many of which contain incomplete and/or inaccurate information.
In any case, the way to convert a UNIX timestamp into an actual date would be to use this formula:
DATETIME_PARSE( {Your Unix Timestamp Field}, 'x' )
And if your UNIX timestamp doesn’t contain milliseconds (i.e. it only goes up to seconds), you could use a capital letter X like this:
DATETIME_PARSE( {Your Unix Timestamp Field}, 'X' )
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.