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:
1. By the current locale on the machine.
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.
For example:en-US – “dddd, MMMM dd, yyyy” → Monday, June 04, 2018
de-DE – “dddd, d. MMMM yyyy” → Monday, 4. June 2018
C# standard formatting rules can be found here:
1. To get the month as 3 letters use: "MMM"
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
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
- Input: 2018-04-25
- Output: April
- Input: 2018-04-25
- Output: Wed
- 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 |