Power Automate allows various formatting options for Date/Time values which can be used as a part of several functions including formatDateTime(), convertTimeZone(), utcNow(), addToTime(), addDays(), addHours(), addMinutes(), addSeconds() etc. Use this tool to test and configure various output formats. You must be converting from the ISO 8601 format ("yyyy-MM-ddTHH:mm:ssZ").
Note that there can be differences depending on your locale and also variations in Power Automate output. Learn more:
| YEAR | MON | DAY | HOUR | MIN | SEC |
| 1 LETTER CODES | DESCRIPTION | OUTPUT |
| d | Short date pattern | |
| D | Long date pattern | |
| f | Full date/time pattern (short time) | |
| F | Full date/time pattern (long time) | |
| g | General date/time pattern (short time) | |
| G | General date/time pattern (long time) | |
| M or m | Month/day pattern | |
| s | Sortable date/time pattern | |
| t | Short time pattern | |
| T | Long time pattern | |
| u | Universal sortable date/time pattern | |
| U | Universal full date/time pattern | |
| Y or y | Year month pattern | |
| DATE PARTS | DESCRIPTION | OUTPUT |
| d | Day of the month, from 1 to 31 | |
| dd | Day of the month, from 01 to 31 | |
| ddd | Abbreviated name of the day of the week | |
| dddd | Full name of the day of the week | |
| f | Tenths of a second | |
| ff | Hundredths of a second | |
| fff | Milliseconds | |
| F | If not 0, tenths of a second | |
| FF | If not 0, hundredths of a second | |
| FFF | If not 0, milliseconds | |
| h | Hour from 1 to 12 | |
| hh | Hour from 01 to 12 | |
| H | Hour from 0 to 23 | |
| HH | Hour from 00 to 23 | |
| m | Minute from 0 to 59 | |
| mm | Minute from 00 to 59 | |
| M | Month from 1 to 12 | |
| MM | Month from 01 to 12 | |
| MMM | Month from Jan to Dec | |
| MMMM | Month from January to December | |
| s | Seconds from 0 to 59 | |
| ss | Seconds from 00 to 59 | |
| t | A if AM / P if PM | |
| tt | AM or PM | |
| y | Year from 0 to 99 | |
| yy | Year from 00 to 99 | |
| yyy | Year from 001 to 9999 | |
| yyyy | Year from 0001 to 9999 | |
| \ | Escape character |
