Support seconds in Date field

[Blark]

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:mm:ss’)
DATETIME_FORMAT({Created Time}, ‘DD-MM-YYYY h:mm: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

[M_k]

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

[ScottWorld]

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:

Does 'Date' field not record seconds? Dates and timezones

It would appear that the ‘Date’ field does not record seconds. Here’s why I think this: [Screen Shot 2020-05-25 at 3.05.50 PM] Here are the formulas I’m using to expose this: DATETIME_FORMAT({Date (no secs?)}, ‘DD-MM-YYYY h:mm:ss’) DATETIME_FORMAT({Created Time}, ‘DD-MM-YYYY h:mm:ss’) I hope I’m wrong about this. I need to be able to grab seconds from a ‘Date’ record.