SetTimeZone

About this task

SetTimeZone is a Trend Invoke method action.

Purpose

Sets the time zone to the trend control and displays the data based on the selected time zone.

Input

TimeZone Index enumeration published as part of Trend.ocx type library.

Return

Boolean: True or False


Index	Published Enumeration List Trend Type Library- TREND_TIME_ZONE_INFO
0	TREND_TZ_SYSTEM_DEFAULT
1	TREND_TZ_AFGHANISTAN_STANDARD_TIME
2	TREND_TZ_ALASKAN_STANDARD_TIME
3	TREND_TZ_ALEUTIAN_STANDARD_TIME
4	TREND_TZ_ALTAI_STANDARD_TIME
5	TREND_TZ_ARAB_STANDARD_TIME
6	TREND_TZ_ARABIAN_STANDARD_TIME
7	TREND_TZ_ARABIC_STANDARD_TIME
8	TREND_TZ_ARGENTINA_STANDARD_TIME
9	TREND_TZ_ASTRAKHAN_STANDARD_TIME
10	TREND_TZ_ATLANTIC_STANDARD_TIME
11	TREND_TZ_AUS_CENTRAL_STANDARD_TIME
12	TREND_TZ_AUS_CENTRAL_W_STANDARD_TIME
13	TREND_TZ_AUS_EASTERN_STANDARD_TIME
14	TREND_TZ_AZERBAIJAN_STANDARD_TIME
15	TREND_TZ_AZORES_STANDARD_TIME
16	TREND_TZ_BAHIA_STANDARD_TIME
17	TREND_TZ_BANGLADESH_STANDARD_TIME
18	TREND_TZ_BELARUS_STANDARD_TIME
19	TREND_TZ_BOUGAINVILLE_STANDARD_TIME
20	TREND_TZ_CANADA_CENTRAL_STANDARD_TIME
21	TREND_TZ_CAPE_VERDE_STANDARD_TIME
22	TREND_TZ_CAUCASUS_STANDARD_TIME
23	TREND_TZ_CEN_AUSTRALIA_STANDARD_TIME
24	TREND_TZ_CENTRAL_AMERICA_STANDARD_TIME
25	TREND_TZ_CENTRAL_ASIA_STANDARD_TIME
26	TREND_TZ_CENTRAL_BRAZILIAN_STANDARD_TIME
27	TREND_TZ_CENTRAL_EUROPE_STANDARD_TIME
28	TREND_TZ_CENTRAL_EUROPEAN_STANDARD_TIME
29	TREND_TZ_CENTRAL_PACIFIC_STANDARD_TIME
30	TREND_TZ_CENTRAL_STANDARD_TIME
31	TREND_TZ_CENTRAL_STANDARD_TIME_MEXICO
32	TREND_TZ_CHATHAM_ISLANDS_STANDARD_TIME
33	TREND_TZ_CHINA_STANDARD_TIME
34	TREND_TZ_CUBA_STANDARD_TIME
35	TREND_TZ_DATELINE_STANDARD_TIME
36	TREND_TZ_E_AFRICA_STANDARD_TIME
37	TREND_TZ_E_AUSTRALIA_STANDARD_TIME
38	TREND_TZ_E_EUROPE_STANDARD_TIME
39	TREND_TZ_E_SOUTH_AMERICA_STANDARD_TIME
40	TREND_TZ_EASTER_ISLAND_STANDARD_TIME
41	TREND_TZ_EASTERN_STANDARD_TIME
42	TREND_TZ_EASTERN_STANDARD_TIME_MEXICO
43	TREND_TZ_EGYPT_STANDARD_TIME
44	TREND_TZ_EKATERINBURG_STANDARD_TIME
45	TREND_TZ_FIJI_STANDARD_TIME
46	TREND_TZ_FLE_STANDARD_TIME
47	TREND_TZ_GEORGIAN_STANDARD_TIME
48	TREND_TZ_GMT_STANDARD_TIME
49	TREND_TZ_GREENLAND_STANDARD_TIME
50	TREND_TZ_GREENWICH_STANDARD_TIME
51	TREND_TZ_GTB_STANDARD_TIME
52	TREND_TZ_HAITI_STANDARD_TIME
53	TREND_TZ_HAWAIIAN_STANDARD_TIME
54	TREND_TZ_INDIA_STANDARD_TIME
55	TREND_TZ_IRAN_STANDARD_TIME
56	TREND_TZ_ISRAEL_STANDARD_TIME
57	TREND_TZ_JORDAN_STANDARD_TIME
58	TREND_TZ_KALININGRAD_STANDARD_TIME
59	TREND_TZ_KAMCHATKA_STANDARD_TIME
60	TREND_TZ_KOREA_STANDARD_TIME
61	TREND_TZ_LIBYA_STANDARD_TIME
62	TREND_TZ_LINE_ISLANDS_STANDARD_TIME
63	TREND_TZ_LORD_HOWE_STANDARD_TIME
64	TREND_TZ_MAGADAN_STANDARD_TIME
65	TREND_TZ_MAGALLANES_STANDARD_TIME
66	TREND_TZ_MARQUESAS_STANDARD_TIME
67	TREND_TZ_MAURITIUS_STANDARD_TIME
68	TREND_TZ_MID_ATLANTIC_STANDARD_TIME
69	TREND_TZ_MIDDLE_EAST_STANDARD_TIME
70	TREND_TZ_MONTEVIDEO_STANDARD_TIME
71	TREND_TZ_MOROCCO_STANDARD_TIME
72	TREND_TZ_MOUNTAIN_STANDARD_TIME
73	TREND_TZ_MOUNTAIN_STANDARD_TIME_MEXICO
74	TREND_TZ_MYANMAR_STANDARD_TIME
75	TREND_TZ_N_CENTRAL_ASIA_STANDARD_TIME
76	TREND_TZ_NAMIBIA_STANDARD_TIME
77	TREND_TZ_NEPAL_STANDARD_TIME
78	TREND_TZ_NEW_ZEALAND_STANDARD_TIME
79	TREND_TZ_NEWFOUNDLAND_STANDARD_TIME
80	TREND_TZ_NORFOLK_STANDARD_TIME
81	TREND_TZ_NORTH_ASIA_EAST_STANDARD_TIME
82	TREND_TZ_NORTH_ASIA_STANDARD_TIME
83	TREND_TZ_NORTH_KOREA_STANDARD_TIME
84	TREND_TZ_OMSK_STANDARD_TIME
85	TREND_TZ_PACIFIC_SA_STANDARD_TIME
86	TREND_TZ_PACIFIC_STANDARD_TIME
87	TREND_TZ_PACIFIC_STANDARD_TIME_MEXICO
88	TREND_TZ_PAKISTAN_STANDARD_TIME
89	TREND_TZ_PARAGUAY_STANDARD_TIME
90	TREND_TZ_ROMANCE_STANDARD_TIME
91	TREND_TZ_RUSSIA_TIME_ZONE_10
92	TREND_TZ_RUSSIA_TIME_ZONE_11
93	TREND_TZ_RUSSIA_TIME_ZONE_3
94	TREND_TZ_RUSSIAN_STANDARD_TIME
95	TREND_TZ_SA_EASTERN_STANDARD_TIME
96	TREND_TZ_SA_PACIFIC_STANDARD_TIME
97	TREND_TZ_SA_WESTERN_STANDARD_TIME
98	TREND_TZ_SAINT_PIERRE_STANDARD_TIME
99	TREND_TZ_SAKHALIN_STANDARD_TIME
100	TREND_TZ_SAMOA_STANDARD_TIME
101	TREND_TZ_SARATOV_STANDARD_TIME
102	TREND_TZ_SE_ASIA_STANDARD_TIME
103	TREND_TZ_SINGAPORE_STANDARD_TIME
104	TREND_TZ_SOUTH_AFRICA_STANDARD_TIME
105	TREND_TZ_SRI_LANKA_STANDARD_TIME
106	TREND_TZ_SYRIA_STANDARD_TIME
107	TREND_TZ_TAIPEI_STANDARD_TIME
108	TREND_TZ_TASMANIA_STANDARD_TIME
109	TREND_TZ_TOCANTINS_STANDARD_TIME
110	TREND_TZ_TOKYO_STANDARD_TIME
111	TREND_TZ_TOMSK_STANDARD_TIME
112	TREND_TZ_TONGA_STANDARD_TIME
113	TREND_TZ_TRANSBAIKAL_STANDARD_TIME
114	TREND_TZ_TURKEY_STANDARD_TIME
115	TREND_TZ_TURKS_AND_CAICOS_STANDARD_TIME
116	TREND_TZ_ULAANBAATAR_STANDARD_TIME
117	TREND_TZ_US_EASTERN_STANDARD_TIME
118	TREND_TZ_US_MOUNTAIN_STANDARD_TIME
119	TREND_TZ_UTC
120	TREND_TZ_UTC_PLUS_12
121	TREND_TZ_UTC_PLUS_13
122	TREND_TZ_UTC_MINUS_02
123	TREND_TZ_UTC_MINUS_08
124	TREND_TZ_UTC_MINUS_09
125	TREND_TZ_UTC_MINUS_11
126	TREND_TZ_VENEZUELA_STANDARD_TIME
127	TREND_TZ_VLADIVOSTOK_STANDARD_TIME
128	TREND_TZ_W_AUSTRALIA_STANDARD_TIME
129	TREND_TZ_W_CENTRAL_AFRICA_STANDARD_TIME
130	TREND_TZ_W_EUROPE_STANDARD_TIME
131	TREND_TZ_W_MONGOLIA_STANDARD_TIME
132	TREND_TZ_WEST_ASIA_STANDARD_TIME
133	TREND_TZ_WEST_BANK_STANDARD_TIME
134	TREND_TZ_WEST_PACIFIC_STANDARD_TIME
135	TREND_TZ_YAKUTSK_STANDARD_TIME

Sample Code

Dim oTrend As TrendLib.ITrend
Dim bRet As Boolean
 
Set oTrend = CimGetScreen.Object.Objects.Item("Trend1").OLEObject
bRet = oTrend.SetTimeZone( TREND_TZ_INDIA_STANDARD_TIME )
 
Or
bRet = oTrend.SetTimeZone( 54 )

Basic Script Methods

Procedure

SetTimeComponentsHR_Ex (param1, param2, param3, param4, param5, param6, param7, param8, param9, param10)

Purpose: Given components of the time based on time zone. Current time divided into time components of year, month, day, hour, minute, second, and nanosecond.


Param1	Double	Low value of input time
Param2	Double	High value of input time
Param3	Integer	Timecomponent
Param4	Integer	Timecomponent
Param5	Integer	Timecomponent
Param6	Integer	Timecomponent
Param7	Integer	Timecomponent
Param8	Integer	Timecomponent
Param9	Long	Nanosecond time component
Param10	Integer	TimeZoneIndex

Where Time Zone Index can be either

Trend Lib TREND_TIME_ZONE_INFO (If there is a CimView screen reference to the trend.ocx file)

an index number in the list below:


Index	Enumeration
0	COR_CIMP_SYSTEM_DEFAULT
1	COR_CIMP_AFGHANISTAN_STANDARD_TIME
2	COR_CIMP_ALASKAN_STANDARD_TIME
3	COR_CIMP_ALEUTIAN_STANDARD_TIME
4	COR_CIMP_ALTAI_STANDARD_TIME
5	COR_CIMP_ARAB_STANDARD_TIME
6	COR_CIMP_ARABIAN_STANDARD_TIME
7	COR_CIMP_ARABIC_STANDARD_TIME
8	COR_CIMP_ARGENTINA_STANDARD_TIME
9	COR_CIMP_ASTRAKHAN_STANDARD_TIME
10	COR_CIMP_ATLANTIC_STANDARD_TIME
11	COR_CIMP_AUS_CENTRAL_STANDARD_TIME
12	COR_CIMP_AUS_CENTRAL_W_STANDARD_TIME
13	COR_CIMP_AUS_EASTERN_STANDARD_TIME
14	COR_CIMP_AZERBAIJAN_STANDARD_TIME
15	COR_CIMP_AZORES_STANDARD_TIME
16	COR_CIMP_BAHIA_STANDARD_TIME
17	COR_CIMP_BANGLADESH_STANDARD_TIME
18	COR_CIMP_BELARUS_STANDARD_TIME
19	COR_CIMP_BOUGAINVILLE_STANDARD_TIME
20	COR_CIMP_CANADA_CENTRAL_STANDARD_TIME
21	COR_CIMP_CAPE_VERDE_STANDARD_TIME
22	COR_CIMP_CAUCASUS_STANDARD_TIME
23	COR_CIMP_CEN_AUSTRALIA_STANDARD_TIME
24	COR_CIMP_CENTRAL_AMERICA_STANDARD_TIME
25	COR_CIMP_CENTRAL_ASIA_STANDARD_TIME
26	COR_CIMP_CENTRAL_BRAZILIAN_STANDARD_TIME
27	COR_CIMP_CENTRAL_EUROPE_STANDARD_TIME
28	COR_CIMP_CENTRAL_EUROPEAN_STANDARD_TIME
29	COR_CIMP_CENTRAL_PACIFIC_STANDARD_TIME
30	COR_CIMP_CENTRAL_STANDARD_TIME
31	COR_CIMP_CENTRAL_STANDARD_TIME_MEXICO
32	COR_CIMP_CHATHAM_ISLANDS_STANDARD_TIME
33	COR_CIMP_CHINA_STANDARD_TIME
34	COR_CIMP_CUBA_STANDARD_TIME
35	COR_CIMP_DATELINE_STANDARD_TIME
36	COR_CIMP_E_AFRICA_STANDARD_TIME
37	COR_CIMP_E_AUSTRALIA_STANDARD_TIME
38	COR_CIMP_E_EUROPE_STANDARD_TIME
39	COR_CIMP_E_SOUTH_AMERICA_STANDARD_TIME
40	COR_CIMP_EASTER_ISLAND_STANDARD_TIME
41	COR_CIMP_EASTERN_STANDARD_TIME
42	COR_CIMP_EASTERN_STANDARD_TIME_MEXICO
43	COR_CIMP_EGYPT_STANDARD_TIME
44	COR_CIMP_EKATERINBURG_STANDARD_TIME
45	COR_CIMP_FIJI_STANDARD_TIME
46	COR_CIMP_FLE_STANDARD_TIME
47	COR_CIMP_GEORGIAN_STANDARD_TIME
48	COR_CIMP_GMT_STANDARD_TIME
49	COR_CIMP_GREENLAND_STANDARD_TIME
50	COR_CIMP_GREENWICH_STANDARD_TIME
51	COR_CIMP_GTB_STANDARD_TIME
52	COR_CIMP_HAITI_STANDARD_TIME
53	COR_CIMP_HAWAIIAN_STANDARD_TIME
54	COR_CIMP_INDIA_STANDARD_TIME
55	COR_CIMP_IRAN_STANDARD_TIME
56	COR_CIMP_ISRAEL_STANDARD_TIME
57	COR_CIMP_JORDAN_STANDARD_TIME
58	COR_CIMP_KALININGRAD_STANDARD_TIME
59	COR_CIMP_KAMCHATKA_STANDARD_TIME
60	COR_CIMP_KOREA_STANDARD_TIME
61	COR_CIMP_LIBYA_STANDARD_TIME
62	COR_CIMP_LINE_ISLANDS_STANDARD_TIME
63	COR_CIMP_LORD_HOWE_STANDARD_TIME
64	COR_CIMP_MAGADAN_STANDARD_TIME
65	COR_CIMP_MAGALLANES_STANDARD_TIME
66	COR_CIMP_MARQUESAS_STANDARD_TIME
67	COR_CIMP_MAURITIUS_STANDARD_TIME
68	COR_CIMP_MID_ATLANTIC_STANDARD_TIME
69	COR_CIMP_MIDDLE_EAST_STANDARD_TIME
70	COR_CIMP_MONTEVIDEO_STANDARD_TIME
71	COR_CIMP_MOROCCO_STANDARD_TIME
72	COR_CIMP_MOUNTAIN_STANDARD_TIME
73	COR_CIMP_MOUNTAIN_STANDARD_TIME_MEXICO
74	COR_CIMP_MYANMAR_STANDARD_TIME
75	COR_CIMP_N_CENTRAL_ASIA_STANDARD_TIME
76	COR_CIMP_NAMIBIA_STANDARD_TIME
77	COR_CIMP_NEPAL_STANDARD_TIME
78	COR_CIMP_NEW_ZEALAND_STANDARD_TIME
79	COR_CIMP_NEWFOUNDLAND_STANDARD_TIME
80	COR_CIMP_NORFOLK_STANDARD_TIME
81	COR_CIMP_NORTH_ASIA_EAST_STANDARD_TIME
82	COR_CIMP_NORTH_ASIA_STANDARD_TIME
83	COR_CIMP_NORTH_KOREA_STANDARD_TIME
84	COR_CIMP_OMSK_STANDARD_TIME
85	COR_CIMP_PACIFIC_SA_STANDARD_TIME
86	COR_CIMP_PACIFIC_STANDARD_TIME
87	COR_CIMP_PACIFIC_STANDARD_TIME_MEXICO
88	COR_CIMP_PAKISTAN_STANDARD_TIME
89	COR_CIMP_PARAGUAY_STANDARD_TIME
90	COR_CIMP_ROMANCE_STANDARD_TIME
91	COR_CIMP_RUSSIA_TIME_ZONE_10
92	COR_CIMP_RUSSIA_TIME_ZONE_11
93	COR_CIMP_RUSSIA_TIME_ZONE_3
94	COR_CIMP_RUSSIAN_STANDARD_TIME
95	COR_CIMP_SA_EASTERN_STANDARD_TIME
96	COR_CIMP_SA_PACIFIC_STANDARD_TIME
97	COR_CIMP_SA_WESTERN_STANDARD_TIME
98	COR_CIMP_SAINT_PIERRE_STANDARD_TIME
99	COR_CIMP_SAKHALIN_STANDARD_TIME
100	COR_CIMP_SAMOA_STANDARD_TIME
101	COR_CIMP_SARATOV_STANDARD_TIME
102	COR_CIMP_SE_ASIA_STANDARD_TIME
103	COR_CIMP_SINGAPORE_STANDARD_TIME
104	COR_CIMP_SOUTH_AFRICA_STANDARD_TIME
105	COR_CIMP_SRI_LANKA_STANDARD_TIME
106	COR_CIMP_SYRIA_STANDARD_TIME
107	COR_CIMP_TAIPEI_STANDARD_TIME
108	COR_CIMP_TASMANIA_STANDARD_TIME
109	COR_CIMP_TOCANTINS_STANDARD_TIME
110	COR_CIMP_TOKYO_STANDARD_TIME
111	COR_CIMP_TOMSK_STANDARD_TIME
112	COR_CIMP_TONGA_STANDARD_TIME
113	COR_CIMP_TRANSBAIKAL_STANDARD_TIME
114	COR_CIMP_TURKEY_STANDARD_TIME
115	COR_CIMP_TURKS_AND_CAICOS_STANDARD_TIME
116	COR_CIMP_ULAANBAATAR_STANDARD_TIME
117	COR_CIMP_US_EASTERN_STANDARD_TIME
118	COR_CIMP_US_MOUNTAIN_STANDARD_TIME
119	COR_CIMP_UTC
120	COR_CIMP_UTC_PLUS_12
121	COR_CIMP_UTC_PLUS_13
122	COR_CIMP_UTC_MINUS_02
123	COR_CIMP_UTC_MINUS_08
124	COR_CIMP_UTC_MINUS_09
125	COR_CIMP_UTC_MINUS_11
126	COR_CIMP_VENEZUELA_STANDARD_TIME
127	COR_CIMP_VLADIVOSTOK_STANDARD_TIME
128	COR_CIMP_W_AUSTRALIA_STANDARD_TIME
129	COR_CIMP_W_CENTRAL_AFRICA_STANDARD_TIME
130	COR_CIMP_W_EUROPE_STANDARD_TIME
131	COR_CIMP_W_MONGOLIA_STANDARD_TIME
132	COR_CIMP_WEST_ASIA_STANDARD_TIME
133	COR_CIMP_WEST_BANK_STANDARD_TIME
134	COR_CIMP_WEST_PACIFIC_STANDARD_TIME
135	COR_CIMP_YAKUTSK_STANDARD_TIME

Sample Code

   Dim yy      As Integer
   Dim mon     As Integer
   Dim dd      As Integer
   Dim hh      As Integer
   Dim min     As Integer
   Dim sec     As Integer
   Dim nano    As Long
   Dim qlow    As Double
   Dim qhigh   As Double

Legend


yy	=	2017
mon	=	10
dd	=	13
hh	=	15
min	=	00
sec	=	00
nano	=	00

SetTimeFromComponentsHR_Ex qlow,qhigh,yy,mon,dd,hh,min,sec,nano,60

SetTimecomponentHR() (param1, param2, param3, param4, param5, param6, param7, param8, param9, param10)


Param1	Double	Low value of input time
Param2	Double	High value of input time
Param3	Integer	Timecomponent
Param4	Integer	Timecomponent
Param5	Integer	Timecomponent
Param6	Integer	Timecomponent
Param7	Integer	Timecomponent
Param8	Integer	Timecomponent
Param9	Long	Nanosecond time component
Param10	Integer	TimeZoneIndex

Sub OnMouseUp (x As Long, y As Logn, flags As Long)

Declare Variables

   Dim yy     As Integer
   Dim mm     As Integer
   Dim dd     As Integer
   Dim hh     As Integer
   Dim min    As Integer
   Dim sec    As Integer
   Dim nano   As Long
   Dim qlow   As Double
   Dim qhigh  As Double

Legend


yy	=	2011
mon	=	7
dd	=	13
hh		15
min	=	43
sec	=	10
nano	=	00

SetTimeFromComponentsHR  qlow,qhigh,yy,mm,dd,hh,min,sec,nano
   MsgBox qhigh
   MsgBox qlow

GetLocalDateAdjustedToTimeZone

Purpose: Converts the local time to specified time zone.


Inputs:	Year	Integer
	Month	Integer
	Day	Integer
	Hour	Integer
	Minutes	Integer
	Seconds	Integer
	Milliseconds	Long
	TimeZoneIndex	Integer

Return:	Adjusted DateTime	Date

Where Time Zone Index can be either

Trend Lib TREND_TIME_ZONE_INFO (If there is a CimView screen reference to the trend.ocx file)

an index number in the list below:


Index	Enumeration
0	COR_CIMP_SYSTEM_DEFAULT
1	COR_CIMP_AFGHANISTAN_STANDARD_TIME
2	COR_CIMP_ALASKAN_STANDARD_TIME
3	COR_CIMP_ALEUTIAN_STANDARD_TIME
4	COR_CIMP_ALTAI_STANDARD_TIME
5	COR_CIMP_ARAB_STANDARD_TIME
6	COR_CIMP_ARABIAN_STANDARD_TIME
7	COR_CIMP_ARABIC_STANDARD_TIME
8	COR_CIMP_ARGENTINA_STANDARD_TIME
9	COR_CIMP_ASTRAKHAN_STANDARD_TIME
10	COR_CIMP_ATLANTIC_STANDARD_TIME
11	COR_CIMP_AUS_CENTRAL_STANDARD_TIME
12	COR_CIMP_AUS_CENTRAL_W_STANDARD_TIME
13	COR_CIMP_AUS_EASTERN_STANDARD_TIME
14	COR_CIMP_AZERBAIJAN_STANDARD_TIME
15	COR_CIMP_AZORES_STANDARD_TIME
16	COR_CIMP_BAHIA_STANDARD_TIME
17	COR_CIMP_BANGLADESH_STANDARD_TIME
18	COR_CIMP_BELARUS_STANDARD_TIME
19	COR_CIMP_BOUGAINVILLE_STANDARD_TIME
20	COR_CIMP_CANADA_CENTRAL_STANDARD_TIME
21	COR_CIMP_CAPE_VERDE_STANDARD_TIME
22	COR_CIMP_CAUCASUS_STANDARD_TIME
23	COR_CIMP_CEN_AUSTRALIA_STANDARD_TIME
24	COR_CIMP_CENTRAL_AMERICA_STANDARD_TIME
25	COR_CIMP_CENTRAL_ASIA_STANDARD_TIME
26	COR_CIMP_CENTRAL_BRAZILIAN_STANDARD_TIME
27	COR_CIMP_CENTRAL_EUROPE_STANDARD_TIME
28	COR_CIMP_CENTRAL_EUROPEAN_STANDARD_TIME
29	COR_CIMP_CENTRAL_PACIFIC_STANDARD_TIME
30	COR_CIMP_CENTRAL_STANDARD_TIME
31	COR_CIMP_CENTRAL_STANDARD_TIME_MEXICO
32	COR_CIMP_CHATHAM_ISLANDS_STANDARD_TIME
33	COR_CIMP_CHINA_STANDARD_TIME
34	COR_CIMP_CUBA_STANDARD_TIME
35	COR_CIMP_DATELINE_STANDARD_TIME
36	COR_CIMP_E_AFRICA_STANDARD_TIME
37	COR_CIMP_E_AUSTRALIA_STANDARD_TIME
38	COR_CIMP_E_EUROPE_STANDARD_TIME
39	COR_CIMP_E_SOUTH_AMERICA_STANDARD_TIME
40	COR_CIMP_EASTER_ISLAND_STANDARD_TIME
41	COR_CIMP_EASTERN_STANDARD_TIME
42	COR_CIMP_EASTERN_STANDARD_TIME_MEXICO
43	COR_CIMP_EGYPT_STANDARD_TIME
44	COR_CIMP_EKATERINBURG_STANDARD_TIME
45	COR_CIMP_FIJI_STANDARD_TIME
46	COR_CIMP_FLE_STANDARD_TIME
47	COR_CIMP_GEORGIAN_STANDARD_TIME
48	COR_CIMP_GMT_STANDARD_TIME
49	COR_CIMP_GREENLAND_STANDARD_TIME
50	COR_CIMP_GREENWICH_STANDARD_TIME
51	COR_CIMP_GTB_STANDARD_TIME
52	COR_CIMP_HAITI_STANDARD_TIME
53	COR_CIMP_HAWAIIAN_STANDARD_TIME
54	COR_CIMP_INDIA_STANDARD_TIME
55	COR_CIMP_IRAN_STANDARD_TIME
56	COR_CIMP_ISRAEL_STANDARD_TIME
57	COR_CIMP_JORDAN_STANDARD_TIME
58	COR_CIMP_KALININGRAD_STANDARD_TIME
59	COR_CIMP_KAMCHATKA_STANDARD_TIME
60	COR_CIMP_KOREA_STANDARD_TIME
61	COR_CIMP_LIBYA_STANDARD_TIME
62	COR_CIMP_LINE_ISLANDS_STANDARD_TIME
63	COR_CIMP_LORD_HOWE_STANDARD_TIME
64	COR_CIMP_MAGADAN_STANDARD_TIME
65	COR_CIMP_MAGALLANES_STANDARD_TIME
66	COR_CIMP_MARQUESAS_STANDARD_TIME
67	COR_CIMP_MAURITIUS_STANDARD_TIME
68	COR_CIMP_MID_ATLANTIC_STANDARD_TIME
69	COR_CIMP_MIDDLE_EAST_STANDARD_TIME
70	COR_CIMP_MONTEVIDEO_STANDARD_TIME
71	COR_CIMP_MOROCCO_STANDARD_TIME
72	COR_CIMP_MOUNTAIN_STANDARD_TIME
73	COR_CIMP_MOUNTAIN_STANDARD_TIME_MEXICO
74	COR_CIMP_MYANMAR_STANDARD_TIME
75	COR_CIMP_N_CENTRAL_ASIA_STANDARD_TIME
76	COR_CIMP_NAMIBIA_STANDARD_TIME
77	COR_CIMP_NEPAL_STANDARD_TIME
78	COR_CIMP_NEW_ZEALAND_STANDARD_TIME
79	COR_CIMP_NEWFOUNDLAND_STANDARD_TIME
80	COR_CIMP_NORFOLK_STANDARD_TIME
81	COR_CIMP_NORTH_ASIA_EAST_STANDARD_TIME
82	COR_CIMP_NORTH_ASIA_STANDARD_TIME
83	COR_CIMP_NORTH_KOREA_STANDARD_TIME
84	COR_CIMP_OMSK_STANDARD_TIME
85	COR_CIMP_PACIFIC_SA_STANDARD_TIME
86	COR_CIMP_PACIFIC_STANDARD_TIME
87	COR_CIMP_PACIFIC_STANDARD_TIME_MEXICO
88	COR_CIMP_PAKISTAN_STANDARD_TIME
89	COR_CIMP_PARAGUAY_STANDARD_TIME
90	COR_CIMP_ROMANCE_STANDARD_TIME
91	COR_CIMP_RUSSIA_TIME_ZONE_10
92	COR_CIMP_RUSSIA_TIME_ZONE_11
93	COR_CIMP_RUSSIA_TIME_ZONE_3
94	COR_CIMP_RUSSIAN_STANDARD_TIME
95	COR_CIMP_SA_EASTERN_STANDARD_TIME
96	COR_CIMP_SA_PACIFIC_STANDARD_TIME
97	COR_CIMP_SA_WESTERN_STANDARD_TIME
98	COR_CIMP_SAINT_PIERRE_STANDARD_TIME
99	COR_CIMP_SAKHALIN_STANDARD_TIME
100	COR_CIMP_SAMOA_STANDARD_TIME
101	COR_CIMP_SARATOV_STANDARD_TIME
102	COR_CIMP_SE_ASIA_STANDARD_TIME
103	COR_CIMP_SINGAPORE_STANDARD_TIME
104	COR_CIMP_SOUTH_AFRICA_STANDARD_TIME
105	COR_CIMP_SRI_LANKA_STANDARD_TIME
106	COR_CIMP_SYRIA_STANDARD_TIME
107	COR_CIMP_TAIPEI_STANDARD_TIME
108	COR_CIMP_TASMANIA_STANDARD_TIME
109	COR_CIMP_TOCANTINS_STANDARD_TIME
110	COR_CIMP_TOKYO_STANDARD_TIME
111	COR_CIMP_TOMSK_STANDARD_TIME
112	COR_CIMP_TONGA_STANDARD_TIME
113	COR_CIMP_TRANSBAIKAL_STANDARD_TIME
114	COR_CIMP_TURKEY_STANDARD_TIME
115	COR_CIMP_TURKS_AND_CAICOS_STANDARD_TIME
116	COR_CIMP_ULAANBAATAR_STANDARD_TIME
117	COR_CIMP_US_EASTERN_STANDARD_TIME
118	COR_CIMP_US_MOUNTAIN_STANDARD_TIME
119	COR_CIMP_UTC
120	COR_CIMP_UTC_PLUS_12
121	COR_CIMP_UTC_PLUS_13
122	COR_CIMP_UTC_MINUS_02
123	COR_CIMP_UTC_MINUS_08
124	COR_CIMP_UTC_MINUS_09
125	COR_CIMP_UTC_MINUS_11
126	COR_CIMP_VENEZUELA_STANDARD_TIME
127	COR_CIMP_VLADIVOSTOK_STANDARD_TIME
128	COR_CIMP_W_AUSTRALIA_STANDARD_TIME
129	COR_CIMP_W_CENTRAL_AFRICA_STANDARD_TIME
130	COR_CIMP_W_EUROPE_STANDARD_TIME
131	COR_CIMP_W_MONGOLIA_STANDARD_TIME
132	COR_CIMP_WEST_ASIA_STANDARD_TIME
133	COR_CIMP_WEST_BANK_STANDARD_TIME
134	COR_CIMP_WEST_PACIFIC_STANDARD_TIME
135	COR_CIMP_YAKUTSK_STANDARD_TIME

Sample code

   Dim yy       As Integer
   Dim mon      As Integer
   Dim dd       As Integer
   Dim hh       As Integer
   Dim min      As Integer
   Dim sec      As Integer
   Dim nano     As Long
   Dim adjDate  As Date

local time 2017 Oct 13 3 PM

Legend


yy	=	2017
mon	=	10
dd	=	13
hh	=	15
min	=	00
sec	=	00
nano	=	00

Conversion to Korean Time

adjDate = GetLocalDateAdjustedToTimeZone(yy,mon,dd,hh,min,sec,nano,TREND_TZ_KOREA_STANDARD_TIME)

adjDate = GetLocalDateAdjustedToTimeZone(yy,mon,dd,hh,min,sec,nano,60)

MsgBox format$(adjDate, "m/d/yyyy:hh:n:ss")

Return

2017 Oct 14 4 AM