Help

Date to unix time stamp

5797 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Roberto_Ceccher
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi, i’m new to airtable and i want to know if there is a eway to abtain a unix time stamp from a date.
TY

5 Replies 5

Yep… use a formula field with the DATETIME_FORMAT() function. Pass it a date field (or an arbitrary date) and format it to use the unix timestamp as output.

5f73751092c6afb3485d0dfe997b3809227f5002.png

Supported format specifiers for DATETIME_FORMAT

The DATETIME_FORMAT function will allow you to reformat the data from the date-type field into a string of your specifications. This is written in the form "DATETIME_FORMAT(Datetime, 'format s...


image


DATETIME_FORMAT({Date}, 'X')
Roberto_Ceccher
5 - Automation Enthusiast
5 - Automation Enthusiast

TY so much, you have solved my problem

Roberto_Ceccher
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi, Jeremy u use Voiceflow Creator?

I don’t… sorry (these characters are here to reach the minimum limit for post)

Roberto_Ceccher
5 - Automation Enthusiast
5 - Automation Enthusiast

ok ty so much (these characters are here to reach the minimum limit for post)