Supported date and time formats in eADM Translations test

This article serves as a reference guide to the date and time formats supported by Identum's eADM . It includes a comprehensive table with format strings, examples, and descriptions for use in CSV data imports, exports, and when defining criteria in rulesets. The document helps administrators ensure correct date parsing and prevent errors during system integration and automation tasks.

The eADM is designed to parse several different date and time formats. This flexibility allows administrators to work with various data sources, especially when handling CSV files for user import/export or when defining criteria in rulesets.

When you provide a date or time value in a source file or in a ruleset, eADM to parse it using the formats listed below. The system processes them in a specific order, so it is important to ensure your data is consistent and matches one of the supported formats to avoid errors.

Note: Date and time parsing in eADM culture-invariant. This means it uses a standardized format that is not affected by regional settings (e.g., dd.MM.yyyy is always day-month-year, regardless of the server's or user's local settings).

Note 2: When working with dates in objects using the API, dd/MM/yyyy HH:mm:ss is the primary format.

Supported formats

The following table lists all supported date and time format strings, along with an example and a description for each.

Format String	Example	Description
`dd/MM/yyyy HH:mm:ss`	`August 21, 2025, 2:30:05 p.m.`	Day, month, year with a 24-hour timestamp including seconds. This is the primary format when working with objects in the APIs
`yyyy-MM-dd HH:mm:ss`	`August 21, 2025, 2:30:05 p.m.`	ISO-style date with a 24-hour timestamp that includes seconds.
`M/dd/yyyy h:mm:ss tt`	`August 21, 2025, 2:30:05 p.m.`	US-style date format with a 12-hour time format and AM/PM indicator.
`M/d/yyyy hh:mm:ss tt`	`September 8, 2025, 2:30:05 p.m.`	US-style date (single-digit day) with a 12-hour time format and AM/PM indicator.
`yyyy-MM-dd`	`August 21, 2025`	ISO 8601 standard date format (date only).
`dd.MM.yyyy`	`21.08.2025`	Day, month, year (date only).
`dd/MM/yyyy HH:mm`	`August 21, 2025, 2:30 p.m.`	Day, month, and year with a 24-hour time format (without seconds).
`dd/MM/yyyy hh:mm:ss`	`August 21, 2025, 2:30:05 a.m.`	Day, month, and year with a 12-hour time format.
`dd/MM/yyyy HH:mm:ss`	`August 21, 2025, 2:30:05 p.m.`	Day, month, and year with a 24-hour time format.
`dd/MM/yyyy HH:mm`	`21.08.2025 14.30`	Day, month, year with a 24-hour time format (dot separator for the hour).
`yyyyMMdd`	`20250821`	Basic ISO date format without separators.
`yyyy-MM-dd HH:mm:ss`	`August 21, 2025, 2:30:05 PM`	ISO 8601 combined date and time format using a "T" separator.

Understanding the format specifiers

The format strings in the table above use the following standard specifiers.

yyyy: The year as a four-digit number.
MM: The month, starting from 01 through 12.
M: The month, starting from 1 through 12.
dd: The day of the month, from 01 through 31.
d: The day of the month, from 1 through 31.
HH: The time, using a 24-hour clock from 00 two 23.
hh: The time, using a 12-hour clock from 01 two 12.
mm: The minute, from 00 two 59.
ss: The second, from 00 two 59.
tt: The AM/PM designator.
T: The literal character 'T', used as a separator in the ISO 8601 standard.