Salesforce

GetDate (Magic xpi 4.13)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

GetDate (Magic xpi 4.13)

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?, Century

Reference
Attachment 
Attachment