Skip to main content
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
Be the first to reply!

Reply