Datetime Field Types

These field types use dataType: 'datetime'.

Field Type	Stored Value
Datetime	Date and time, returned as YYYY-MM-DD HH:mm:ss
Summary	Datetime result when the summary function returns a datetime
Dynamic Formula	Datetime result when the formula result type is datetime

Convert to Date only when the script needs timestamp arithmetic:

const submittedAt = new Date(String(record.data.submitted_at || '').replace(' ', 'T'));
if (Number.isNaN(submittedAt.getTime())) {
  throw new Error('SUBMITTED_AT_INVALID');
}