Skip to main content

It would appear that the ‘Date’ field does not record seconds.

Here’s why I think this:

Here are the formulas I’m using to expose this:
DATETIME_FORMAT({Date (no secs?)}, ‘DD-MM-YYYY h🇲🇲ss’)
DATETIME_FORMAT({Created Time}, ‘DD-MM-YYYY h🇲🇲ss’)

I hope I’m wrong about this. I need to be able to grab seconds from a ‘Date’ record.

View discussion of this in Dates and Timezones category

Hi @Blark


Perhaps you could try the link below.


Hope it helps!


Mary Kay


https://support.airtable.com/hc/en-us/articles/226061308-Supported-unit-specifiers-for-DATETIME-DIFF

This would be a pretty nice feature to have.


Even if Airtable didn’t visually display the seconds & milliseconds by default, it would be nice to know that date fields had that information stored within them, and that we could access that information with either:


(a) formula fields

or

(b) additional formatting choices in the date field.


It sounds like the Airtable API does allow putting seconds into date fields, but we can’t use the Airtable interface to put seconds into date fields.


Further discussion of this here:

I was trying to do rollup fields to find the most recent of an array and there were too many form collisions at the minute level. Unfortunately creating a string output (with seconds) with this information is not helpful, because then you'd need to re-parse it to do any date math. I had to convert timestamps to unix timestamps in seconds and compare those instead like so 

DATETIME_DIFF(formTimestamp, "1970-01-01", "seconds")
Rollup of MAX(values) of that field then works fine.
Granted this limitation is not ideal for many reasons, but the workaround does work.

Upvote. Still not possible to enter seconds in a Date field. If I use the Cmd+; keyboard shortcut (date/time right now), I do get seconds, but I often need to retroactively enter times. I'm logging start and end times of records that often have less than 1 minute between them. This seems pretty standard and I don't understand why we are restricted to minutes.

Upvote! Please allow us to make use of a seconds if need be!

Reply


Terms & Conditions