30+ No code DateTime formats with UiPath activity

[Marius_Puscasu]

Dear community,

The Format Value activity helps us to format a generic value into more that 30+ datetime formats, without being necessary to write any VB or C# code.

1. How to use the activity?

2. How your formatted values looks for different datetime patterns?

Patern	Output Value
MM/dd/yyyy	10/18/2022
yyyy-MM-dd	2022-10-18
dddd, dd MMMM yyyy	Tuesday, 18 October 2022
dddd, dd MMMM yyyy HH:mm	Tuesday, 18 October 2022 14:29
dddd, dd MMMM yyyy hh:mm tt	Tuesday, 18 October 2022 02:29 PM
dddd, dd MMMM yyyy H:mm	Tuesday, 18 October 2022 14:29
dddd, dd MMMM yyyy h:mm tt	Tuesday, 18 October 2022 2:29 PM
dddd, dd MMMM yyyy HH:mm:ss	Tuesday, 18 October 2022 14:29:22
MM/dd/yyyy HH:mm	10/18/2022 14:29
MM/dd/yyyy hh:mm tt	10/18/2022 02:29 PM
MM/dd/yyyy H:mm	10/18/2022 14:29
MM/dd/yyyy h:mm tt	10/18/2022 2:29 PM
yyyy-MM-dd HH:mm	2022-10-18 14:29
yyyy-MM-dd hh:mm tt	2022-10-18 02:29 PM
yyyy-MM-dd H:mm	2022-10-18 14:29
yyyy-MM-dd h:mm tt	2022-10-18 2:29 PM
MM/dd/yyyy HH:mm:ss	10/18/2022 14:29:22
yyyy-MM-dd HH:mm:ss	2022-10-18 14:29:22
MMMM dd	October 18
yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK	2022-10-18T14:29:22.5432798+03:00
ddd, dd MMM yyyy HH':'mm':'ss 'GMT'	Tue, 18 Oct 2022 14:29:22 GMT
yyyy'-'MM'-'dd'T'HH':'mm':'ss	2022-10-18T14:29:22
HH:mm	14:29
hh:mm tt	02:29 PM
H:mm	14:29
h:mm tt	2:29 PM
HH:mm:ss	14:29:22
yyyy'-'MM'-'dd HH':'mm':'ss'Z'	2022-10-18 14:29:22Z
dddd, dd MMMM yyyy HH:mm:ss	Tuesday, 18 October 2022 14:29:22
yyyy MMMM	2022 October

3. What is the meaning of a selected format specifier from your datetime pattern?

Format specifier	Description	Example
dd	The day of the month, from 01 through 31.	14
ddd	The abbreviated name of the day of the week.	Tue
dddd	The full name of the day of the week.	Tuesday
fffffff	The ten millionths of a second in a date and time value.	5432798
h	The hour, using a 12-hour clock from 1 to 12.	2
hh	The hour, using a 12-hour clock from 01 to 12.	02
H	The hour, using a 24-hour clock from 0 to 23.	14
HH	The hour, using a 24-hour clock from 00 to 23.	14
K	Time zone information.	+03:00
mm	The minute, from 00 through 59.	29
MM	The month, from 01 through 12.	10
MMM	The abbreviated name of the month.	Oct
MMMM	The full name of the month.	October
ss	The second, from 00 through 59.	22
tt	The AM/PM designator.	PM
yyyy	The year as a four-digit number.	2022
:	The time separator.	:
/	The date separator.	/
Any other character	The character is copied to the result string unchanged.	GMT; Z

References:

1. Format Value activity: https://docs.uipath.com/activities/docs/format-value

2. .Net - Custom date and time format strings https://learn.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings

Happy automation!