Date to unix time stamp

[Roberto_Ceccher]

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

[Jeremy_Oglesby]

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.

Airtable - Support

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...

---

DATETIME_FORMAT({Date}, 'X')

[Roberto_Ceccher]

TY so much, you have solved my problem

[Roberto_Ceccher]

Hi, Jeremy u use Voiceflow Creator?

[Jeremy_Oglesby]

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

[Roberto_Ceccher]

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