Date Formatter
For custom-delimited date formats, you have to pull out the date (or time) components from a DateTimeFormat object (which is part of the ECMAScript Internationalization API), and then manually create a string with the delimiters you want. To do this, you can use DateTimeFormat#formatToParts. Dates Are Numbers In Excel, dates are stored as numbers - number 1 is the date January 1, 1990. You can format positive numbers in one of the date formats, to see the date that they represent. NOTE: The latest date allowed for calculation in Excel is, which is the number 2958465.
Under 'Date formats,' you'll notice there is more flexibility to change the date format. For example, you can edit Short date to show date with dashes or dots. However, unlike time.
Scenario
When working with date and time values (ie. DateTime values) in flow, they may look like:
2019-12-06T22:47:23.0798367Z
2009-06-15T13:45:30Z
You may format these values to look like:
6/15/2009 1:45 PM
Monday, June 15, 2009
This is done through the use of Date and Time Format Strings passed to the formatDateTime() function.
Format Strings
Iso 8601 Date Formatter
A standard format string is a single character (ex. 'd', 'g', 'G', this is case-sensitive) that corresponds to a specific pattern.
For example the format string 'g' corresponds to the General date/time pattern (short time):
- formatDateTime
('2009-06-15T13:45:30', 'g') -> 6/15/2009 1:45 PM
A custom format string is any string with more than one character (ex. 'M/dd/yyyy h:mm tt') that can control the visibility, positioning, precision of the month, day, hour, second etc. of the DateTime value.
For example the format string 'M/dd/yyyy h:mm tt' represents the same pattern as the standard format string 'g' as described above:
- formatDateTime
('2009-06-15T13:45:30', 'M/dd/yyyy h:mm tt') -> 6/15/2009 1:45 PM
Date Formatter Swift
See belowfor more information about available standard format patterns and how to construct a custom format string.
Example Steps
Date Formatter Java
Select the input field where you want the formatted DateTime value
Go to the expression editor ('Add dynamic content' -> click on 'Expression' tab)
Type formatDateTime() (or look under 'Date and time' functions)
Provide the value (can be dynamic content) to be formatted (surrounded by single quotes)
Provide the format string (surrounded by single quotes)
The full expression should look like:
formatDateTime('<your-value>', 'dd/MM/yyyy hh:mm tt')Click 'Ok'