Skip to main content

Date to unix time stamp

  • December 14, 2018
  • 5 replies
  • 153 views

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

Forum|alt.badge.img+18

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.

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')

  • Author
  • Participating Frequently
  • December 14, 2018

TY so much, you have solved my problem


  • Author
  • Participating Frequently
  • December 15, 2018

Hi, Jeremy u use Voiceflow Creator?


Forum|alt.badge.img+18

Hi, Jeremy u use Voiceflow Creator?


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


  • Author
  • Participating Frequently
  • December 15, 2018

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