Supported date and time formats in eADM

This article provides a reference guide to the date and time formats supported by Identum's eADM platform. 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 platform 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 attempts 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 is 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).

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`	`21.08.2025 14:30:05`	Day, month, year with a 24-hour timestamp including seconds.
`yyyy-MM-dd HH:mm:ss`	`2025-08-21 14:30:05`	ISO-style date with a 24-hour timestamp including seconds.
`M/dd/yyyy h:mm:ss tt`	`8/21/2025 2:30:05 PM`	US-style date with a 12-hour timestamp and AM/PM designator.
`M/d/yyyy hh:mm:ss tt`	`8/9/2025 02:30:05 PM`	US-style date (single-digit day) with a 12-hour timestamp and AM/PM designator.
`yyyy-MM-dd`	`2025-08-21`	ISO 8601 standard date format (date only).
`dd.MM.yyyy`	`21.08.2025`	Day, month, year (date only).
`dd.MM.yyyy HH:mm`	`21.08.2025 14:30`	Day, month, year with a 24-hour timestamp without seconds.
`dd/MM/yyyy hh:mm:ss`	`21/08/2025 02:30:05`	Day, month, year with a 12-hour timestamp.
`dd/MM/yyyy HH:mm:ss`	`21/08/2025 14:30:05`	Day, month, year with a 24-hour timestamp.
`dd.MM.yyyy HH.mm`	`21.08.2025 14.30`	Day, month, year with a 24-hour timestamp (dot separator for time).
`yyyyMMdd`	`20250821`	Basic ISO date format with no separators.
`yyyy-MM-ddTHH:mm:ss`	`2025-08-21T14:30:05`	ISO 8601 combined date and time format with 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, from 01 through 12.
M: The month, 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 hour, using a 24-hour clock from 00 to 23.
hh: The hour, using a 12-hour clock from 01 to 12.
mm: The minute, from 00 to 59.
ss: The second, from 00 to 59.
tt: The AM/PM designator.
T: The literal character 'T', used as a separator in the ISO 8601 standard.