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