18 Workday date format masks I didn't know existed

1 day, 17 hours ago Workday Workday Integrations

Did you know that there are "secret" options for formatting dates in a calculated field in Workday?

True Story. Workday only shares 12 options in the date format mask hover text:

Valid Values:
 y - Year (e.g. yy = 08; yyyy = 2008
 M - Month in Year (e.g. MM = 08; MMM = Aug; MMMM = August)
 D - Day in Year
 d - Day in Month
 F - Day of week in Month
 E - Day in Week (e.g. EEE = Tue; EEEE = Tuesday)
 a - a.m./p.m. marker
 H - Hour in Day (0-23)
 h - Hour in a.m./p.m. (1-12)
 m - Minute in Hour
 s - Second in Minute
 S - Millisecond

ICU Date Format

These 12 options are a subset of the 30 ICU Date Format Symbols. I didn't try every single one of the 30 symbols but the few I tested all seem to work! Ymmv.

So for example, say you wanted to include timezone information in the date field, you could try something like these:

yyyy-MM-dd HH:mm:ss z  →  2025-07-29 20:11:16 PDT

yyyy-MM-dd HH:mm:ss Z  →  2025-07-29 20:11:16 -0700

yyyy-MM-dd'T'HH:mm:ssXXX  →  2025-07-29T20:11:16-07:00 (ISO 8601 format)