Format date
Reference documentation for using the Format date expression
Written By Ben Lehmann
Last updated 7 months ago
Purpose | Formats Date/Epoch time into desired format |
Parameters | 1 Boolean, 1 Date/Time or Number and 1 Text Value |
Returns | Text |
Description
The expression will format the provided value in the Date field into formatted text outlined in the Format field. If the Use EPOCH option is selected, the Date field must contain an Epoch timestamp. Otherwise, it should contain a standard Date/Time value.

Comments
When using the Use EPOCH option, you must convert the EPOCH timestamp from seconds to milliseconds (x 100), this can be done by using the multiply expression.
The Format field uses the ISO 6801 Calendar format, this means that a custom date format would look like the following DD/MM/YYYY HH:mm:ss and would return as 29/04/2025 00:00:00.
v3.0