Converts a specific time into another time zone time. 

Syntax

XIH.ConvertToTimeZone(colcaption, TimeZoneID)

XIH.ConvertToTimeZone(colcaption, offset, TimeZoneID)

XIH.ConvertToTimeZone(colIndex, TimeZoneID)

XIH.ConvertToTimeZone(colIndex, offset, TimeZoneID)

Parameters

Parameter

Data type

Description

Sample

colcaption

string

String specifies the columns caption.

"col1"

colIndex

int

Index of a column

0

offset

int

Optionally specifies the row offset. Default is 1.

2

TimeZoneID

string

String specifies to which time zone you want to convert your current time.

"Coordinated Universal Time"

Remarks

columnIndex is zero-based.

Returns a DateTime value.

Examples

XIH.ConvertToTimezone("col1","Central Brazilian Standard Time")
XIH.ConvertToTimezone(3,1,"W. Europe Standard Time")