FORMATDATE

The FORMATDATE function formats the DateTime formatted input data to the specified string.

Input

Number of Connections: 1
InputData TypeDescription
Input1DateTimeThe time data.

Output

OutputData TypeDescription
Output1StringThe formatted input string as specified by the Format property.

Property

NameProperty TypeDescription
FormatString

Specifies how to format the input DateTime data to a string. Reserved pattern letters are listed below:

SymbolMeaningPresentationExample
Gera designator(Text)AD
yyear(Number)2003
Mmonth in year(Text and Number)July and 07
dday in month(Number)10
hhour in am/pm (1-12)(Number)11
Hhour in day (0-23)(Number)0
mminute in hour(Number)45
ssecond in minute(Number)54
Smillisecond(Number)955
Eday in week(Text)Tuesday
Dday in year(Number)145
Fday of week in month(Number)2 (2nd Wed in July)
wweek in year(Number)24
Wweek in month(Number)2
aam/pm marker(Text)PM
khour in day (1-24)(Number)24
Khour in am/pm (0-11)(Number)0
ztime zone(Text)Pacific Standard Time
'escape for text(Delimiter)
''single quote(Literal)'
TimeZonechoiceSpecifies the time zone. If (default) is selected, the system's default time zone is used. If (GMT) is selected, Greenwich Mean Time is used.
LocalechoiceDefines the locale. If (default) is selected, the system's default locale is used.

Topic


Example

PropertyOutput
Input 120030830T12:30:00Formatyyyy/MM/dd2003/08/30
TimeZoneAmerica/New_York
LocaleUS

PropertyOutput
Input 120030830T12:30:00Formatyy/M/d03/8/30
TimeZoneAmerica/New_York
LocaleUS

PropertyOutput
Input 120030830T12:30:00FormatMMMMM dd, yyyy hh:mm aaaAugust 30, 2003 12:30 PM
TimeZoneAmerica/New_York
LocaleUS