Date Parser
Contents
Designed to convert a line with time into user's format. Regional setting and user-defined formats are used for conversion.
Source
Sets source type and name of the variable time to be parsed from.
Format Options
Sets the source format settings.
Format
Sets format of the line with time in the defined variable.
Language
Sets regional settings for the line in the defined variable.
Example
Shows the example of line with time for current settings.
Format Result
Sets the result line creation settings.
Format
Sets format of the line to be created
Language
Sets regional settings for the line to be created.
Example
Shows example of a line for current settings.
Adjust Time Zone
Enables changing time zone of the time being converted into local time zone.
Output Variable
Sets name of the variable the result to be placed into.
Date formats
Format |
Meaning |
Example |
d |
Day of the month as digits without leading zeros for single digit days. |
5 |
dd |
Day of the month as digits with leading zeros for single digit days. |
05 |
ddd |
Day of the week as a three letter abbreviation. |
Mon |
dddd |
Day of the week as its full name. |
Monday |
M |
Month as digits without leading zeros for single digit months. |
1 |
MM |
Month as digits with leading zeros for single digit months. |
01 |
MMM |
Month as a three letter abbreviation. |
jun |
MMMM |
Month as its full name. |
June |
y |
Year represented only by the last digit, if the year is less than 10. Years greater than 10 will be given the value of yy. |
9 |
yy |
Year represented only by the last two digits. |
09 |
yyyy |
Year represented by the full 4 digits. |
1909 |
Time format
Format |
Meaning |
Example |
h |
Hours without leading zeros for single digit hours (12 hour clock). |
1 |
hh |
Hours with leading zeros for single digit hours (12 hour clock). |
01 |
H |
Hours without leading zeros for single digit hours (24 hour clock). |
1 |
HH |
Hours with leading zeros for single digit hours (24 hour clock). |
01 |
m |
Minutes without leading zeros for single digit minutes. |
9 |
mm |
Minutes with leading zeros for single digit minutes. |
09 |
s |
Seconds without leading zeros for single digit seconds. |
5 |
ss |
Seconds with leading zeros for single digit seconds. |
05 |
t |
One character time marker string. This will be the first letter of the values in the AM symbol or PM symbol boxes in Regional Options. |
A |
tt |
Multi-character time marker string. This will be values in the AM symbol or PM symbol boxes in Regional Options. |
AM |