Example of converting date time from UTC to a specific time zone.

edited January 13, 2017 in DevShare Downloads
Example of how to convert time zones. For this example I used a CSV file that includes the current time zones with offsets (these might change). This CSV files is used for a parameter selector. I am using a scripted data set to display 24 rows for 24 hours. This report will then convert these times (assuming they dates are in UTC) to selected time zone.

An alternative approach would be to use public services to get time zone information. Examples are:

Google has one based on geo location - https://developers.google.com/maps/documentation/timezone/intro

Timezonedb has one based on s time zone code - https://timezonedb.com/references/get-time-zone
Sign In or Register to comment.