• AEP Online Help Index

Date Parser

Designed to convert a line with time into user's format. Regional setting and user-defined formats are used for conversion.

Name

Sets name of the variable the result to be placed into.

Input Source

Sets source type and name of the variable time to be parsed from.

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.

Output 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.

Date format:

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