{{sidenavigation.sidenavigationExpandLabel}}
{{getMsg('Help_YouAreHere')}}: {{page.title}} {{page.title}}
{{$root.getMsg("downLoadHelpAsPdf")}} {{helpModel.downloadHelpPdfDataStatus}}

DateTimeWithTimeZoneOffset

This function will assume that the dateTime passed is a datetime of sourceTimeZone. It will then add the difference between the time zone destinationTimeZone and sourceTimeZone to the passed dateTime. The returned datetime will then have the value for desinationTimeZone

Usage:

DateTimeWithTimeZoneOffset( dateTime, sourceTimeZone, destinationTimeZone ) 

Parameters:

dateTime The date time value of time zone sourceTimeZone which should be changed to the value of the time zone destinationTimeZone.
sourceTimeZone The time zone identifier for the dateTime passed. Such as 'CET', 'GMT'. The general format is like this: 'GMT[+ or -]hours[:minutes]' e.g. 'GMT+12'. You can find the ID's at: http://tutorials.jenkov.com/java-date-time/java-util-timezone.html#available-time-zones.
destinationTimeZone The time zone identifier for the dateTime which should be returned.

Returns:

DateTime

Examples:

We assume that we have a date time value like this: December 24th 2005, 11:24:56 AM in Central European Time (CET). Now we want to know what the datetime value is for Greenwich Mean Time (GMT). So we create the following function:

DateTimeWithTimeZoneOffset( DateTime(2005,12,24,11,24,56), 'CET', 'GMT')
-> Returns the datetime value as December 24th 2005, 10:24:56 AM as we
		have one hour difference
between Central European Time (CET) and
		Greenwich Mean Time (GMT).

We assume that we have a date time value like this: July 24th 2005, 11:24:56 AM in Central European Time (CET). Now we want to know what the datetime value is for Greenwich Mean Time (GMT). So we create the following function:

DateTimeWithTimeZoneOffset( DateTime(2005,7,24,11,24,56), 'CET', 'GMT')
-> Returns the datetime value as July 24th 2005, 9:24:56 AM as we
		have one hour difference
between Central European Time (CET) and
		Greenwich Mean Time (GMT) and one our difference additionally
because
		CET has one our of daylight saving time.

See also:

i-net Clear Reports
This application uses cookies to allow login. By continuing to use this application, you agree to the use of cookies.


Help - DateTimeWithTimeZoneOffset