18 Workday date format masks I didn't know existed
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:
Text Only
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: