Skip to main content
Nintex Community Menu Bar

How to Use Format Date Command

  • August 31, 2022
  • 0 replies
  • 255 views
  • Translate

MillaZ
Nintex Employee
Forum|alt.badge.img+21
  • Nintex Employee
  • 678 replies
Product: Kryon RPA
Product Version:
Components: Kryon Studio
Kryon Studio allows you to format dates in a few ways. This can be done with the Format Date Advanced Command. 
Prerequisites: None.
Steps:
 

23933iF4AD5CC370BA696B.jpg

Input:

The Format Date input parsed in 2 ways:

1. By the current locale on the machine.


Examples:

  • English US (en_US) - MM/dd/yyyy → 11/25/1981
  • English UK (en_GB) - dd/MM/yyyy → 25/11/1981

2. By the default format "yyyy-MM-dd" → 1981-11-25

If you want to make it a safe input, you should use the 2nd option.

Output:

To long date - the value of the parsed date string as LongDatePattern property associated with the current culture.
For example:en-US – “dddd, MMMM dd, yyyy” → Monday, June 04, 2018

de-DE – “dddd, d. MMMM yyyy” → Monday, 4. June 2018
  • he-IL – “dddd dd MMMM yyyy” → Monday 04 June 2018
  • To short date - the value of the parsed date string as ShortDatePattern property associated with the current culture.


For example:

  • en-US – “M/d/yyyy” → 6/4/2018
  • de-DE – “dd.MM.yyyy” → 04.06.2018
  • he-IL – “dd/MM/yyyy” → 04/06/2018
Use custom format – manual custom format based on C# DateTime formatting rules.
C# standard formatting rules can be found here:


For example:

1. To get the month as 3 letters use: "MMM"
  • Input: 2018-04-25
  • Output: Apr
2. To get the full month name use: "MMMM"
  • Input: 2018-04-25
  • Output: April
3. To get the day of the week as 3 letters use: "ddd"
  • Input: 2018-04-25
  • Output: Wed
4. To get the full day of the week name use: "dddd"
  • Input: 2018-04-25 
  • Output: Wednesday


Date & time examples for input "2018-06-28 14:46:45":

 
Format Output
R Thu, 28 Jun 2018 14:46:45 GMT
s 2018-06-28T14:46:45
o 2018-06-28T14:46:45.0000000+03:00
Did this topic help you find an answer to your question?

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings