GetDate (Magic xpi 4.5)
Accepts one DateTime string and returns the date section of the input value in Alpha format.
|
Syntax:
|
GetDate(Alpha datetime, Numeric format)
|
|
Parameter:
|
datetime: A DateTime expression.
|
|
|
format:
|
1. YYYY-MM-DDThh:mm:ssTZD (XML format).
|
|
|
|
2. CYYDDD (JDE Julian format), where C is the century (0=1900 and 1=2000), YY is the year and DDD the day of the year.
|
|
Returns:
|
Date section of input datetime value in Alpha format.
|
|
Examples:
|
XML format:
|
GetDate('2008-04-29T10:45:30+5:30',1) returns 2008-04-29.
|
|
|
JDE Julian format:
|
GetDate('111081',2) returns the following date 2011/03/22.
|
|
See also:
|
How Do I Calculate an XML DateTime Format?, How Do I Calculate a Julian Date?
|
