DateParser

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

© 2020 Mediatwins s.r.o. All rights reserved.