Salesforce

GetTimeZone (Magic xpi 4.5)

« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

GetTimeZone (Magic xpi 4.5)

Accepts date and time input and returns the time zone section of the input value in Alpha format.

Syntax:

GetTimeZone(Alpha datetime, Numeric format)

Parameter:

datetime: 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:

Time zone of input datetime value (for example, +02:30).

Examples:

XML format:

GetTimeZone('2008-04-29T10:45:30+5:30',1) returns +5:30.

JDE Julian format:

GetTimeZone('111081',2) returns +5:30.

See also:

How Do I Calculate an XML DateTime Format?, How Do I Calculate a Julian Date?

Reference
Attachment 
Attachment