DateTime Tool

• dd Day of the month as digits with leading zeros for single digit days. (On input, leading zeros are optional.)
• dy. English day of the week as a 3-letter abbreviation. (On input full names are accepted, but Alteryx does not check that the day of the week agrees with the rest of the date.)
• MM Month as digits with leading zeros for single digit months. (On input, leading zeros are optional.)
• Mon. A three letter abbreviation of the English name of the month. (On input, full names are also accepted.)
• Month English name of the Month. (On input, abbreviations are also accepted.)
• yy Year represented only by the last two digits. When converting from a string, two digit years will be mapped into the range from current year minus 66 years to the current year plus 33 years. So, in 2016, a two-digit year will be mapped into the range 1950 to 2049. (On input, four digits will also be accepted.)
• yyyy Year represented by the full four digits. (On input, two digits will also be accepted and mapped as done for the “yy” pattern.)

• HH or hh Hours with leading zeros for single-digit hours (24-hour clock).
• mm Minutes with leading zeros for single-digit minutes.
• ss Seconds with leading zeros for single-digit seconds.

On output, separators in the date/time format are used exactly. On input:

• ‘-‘ and ‘/’ are accepted as equivalent
• white space is ignored
• ‘:’ and ‘,’ must match exactly.