Convert format of date or time

Converts the format of a provided date and/or time format into a specific date & time format.

Common use cases

• Data manipulation Wrkflows
• Time management

Application

• Date & Time

Inputs (what you have)

NAME	DESCRIPTION	TYPE	REQUIRED	EXAMPLE
Date and/or time	Date/Time to be converted	Number	Yes	14 02 22, 13:53
Expected format	Format to convert the provided date/time	Number	Yes	MM/DD/YYYY
Current date/time format	The current format of the provided date/time	Number	Yes	DD MM YY
Number of digits	The number of digits required if converting to Unix Epoch Timestamp	Number	No	13 if 2022-05-01 is equivalent to 1651377600, then three more zeroes need to be added to then end of the timestamp: 1651377600000

Note: the value of inputs can either be a set value in the configuration of the Wrk Action within the Wrkflow, or a variable from the Data Library. These variables in the Data Library are the outputs of previous Wrk Actions in the Wrkflow.

Outputs (what you get)

NAME	DESCRIPTION	TYPE	REQUIRED	EXAMPLE
Converted date/time	Converted date/time	Text	Yes	02/23/2022

Statuses

NAME	DESCRIPTION
Success	This status is selected if the date or time was successfully converted onto the specified format, and the provided link can be used to directly access the file
Unsuccessful	This status is selected in the event of the following scenarios:- The date and time are not provided- The preferred format or current format is not provided- The instructions cannot be followed

How it works

• Convert Date and time: 14 02 22, 13:54, into Date/Time format: mm/dd/yyyy, hh:mm
• The specified Date and time: 14 02 22, 13:54 is then formated into the the specified format
• The calculated result is 02/14/2022 13:54

Year Formats:

Key	Description	Example
yyyy	Year (4 digits)	2023
yy	Year (2 digits)	23

Month Formats:

Key	Description	Example
MMMM	Full month name	October
MMM	Abbreviated month name	Oct
MM	Month (2 digits)	10
M	Month (1 or 2 digits)	10

Day formats:

Key	Description	Example
dd	Day of the month (2 digits)	16
d	Day of the month (1 or 2 digits)	16
J	Day of the year (1 to 3 digits)	289

Week Formats:

Key	Description	Example
F	Day of the week (0 to 6)	0
EEEE	Full weekday name	Sunday
E	Abbreviated weekday name	Sun
W	Week number of the year	41
w	Week number of the year (1 digit)	41

Hour Formats (12 Hr):

Key	Description	Example
hh	Hour (12-hour format, 2 digits)	03
h	Hour (12-hour format, 1 or 2 digits)	3

Hour Formats (24 Hr):

Key	Description	Example
HH	Hour (24-hour format, 2 digits)	15
H	Hour (24-hour format, 1 or 2 digits)	3

Minute Formats:

Key	Description	Example
mm	Minute (2 digits)	05
m	Minute (1 or 2 digits)	5

Second Formats:

Key	Description	Example
SSS	Milliseconds (3 digits)	123
ss	Second (2 digits)	45
s	Second (1 or 2 digits)	5

Timezone and AM / PM:

Key	Description	Example
zzz	Timezone	UTC
a	AM/PM indicator	AM

Requirements

• N/A