TimeZone field format in CRM


I’m sure that everyone of us must have added the field of type Whole number with format TimeZone in at least one CRM implementation. But have you tried to set the value of this field using a custom C# application or a Plugin or Workflow?

Problem with setting the value for this field using C# is that as the field is of type whole number, it accepts only integer value while setting it, but the values for each timezone labels are not mentioned. Also the minimum and maximum range mentioned for whole number field do not apply for format as timezone. Then what are the values for these?

The values ranges from 0 to 300 but this are not in sequence. Below table shows the values for the labels.

0: “Dateline Standard Time”;
1: “Samoa Standard Time”;
2: “Hawaiian Standard Time”;
3: “Alaskan Standard Time”;
4: “Pacific Standard Time”;
5: “Pacific Standard Time (Mexico)”;
6: “UTC-11”;
10: “Mountain Standard Time”;
12: “Mountain Standard Time (Mexico)”;
13: “Mexico Standard Time 2”;
15: “US Mountain Standard Time”;
20: “Central Standard Time”;
25: “Canada Central Standard Time”;
29: “Central Standard Time (Mexico)”;
30: “Mexico Standard Time”;
33: “Central America Standard Time”;
35: “Eastern Standard Time”;
40: “US Eastern Standard Time”;
45: “SA Pacific Standard Time”;
47: “Venezuela Standard Time”;
50: “Atlantic Standard Time”;
55: “SA Western Standard Time”;
56: “Pacific SA Standard Time”;
58: “Central Brazilian Standard Time”;
59: “Paraguay Standard Time”;
60: “Newfoundland Standard Time”;
65: “E. South America Standard Time”;
69: “Argentina Standard Time”;
70: “SA Eastern Standard Time”;
73: “Greenland Standard Time”;
74: “Montevideo Standard Time”;
75: “Mid-Atlantic Standard Time”;
76: “UTC-02”;
80: “Azores Standard Time”;
83: “Cape Verde Standard Time”;
84: “Morocco Standard Time”;
85: “GMT Standard Time”;
90: “Greenwich Standard Time”;
92: “Coordinated Universal Time”;
95: “Central Europe Standard Time”;
100: “Central European Standard Time”;
105: “Romance Standard Time”;
110: “W. Europe Standard Time”;
113: “W. Central Africa Standard Time”;
115: “E. Europe Standard Time”;
120: “Egypt Standard Time”;
125: “FLE Standard Time”;
129: “Jordan Standard Time”;
130: “GTB Standard Time”;
131: “Middle East Standard Time”;
133: “Syria Standard Time”;
135: “Jerusalem Standard Time”;
140: “South Africa Standard Time”;
141: “Namibia Standard Time”;
145: “Russian Standard Time”;
150: “Arab Standard Time”;
155: “E. Africa Standard Time”;
158: “Arabic Standard Time”;
160: “Iran Standard Time”;
165: “Arabian Standard Time”;
169: “Azerbaijan Standard Time”;
170: “Caucasus Standard Time”;
172: “Mauritius Standard Time”;
173: “Georgian Standard Time”;
175: “Afghanistan Standard Time”;
180: “Ekaterinburg Standard Time”;
184: “Pakistan Standard Time”;
185: “West Asia Standard Time”;
190: “India Standard Time”;
193: “Nepal Standard Time”;
195: “Central Asia Standard Time”;
196: “Bangladesh Standard Time”;
200: “Sri Lanka Standard Time”;
201: “N. Central Asia Standard Time”;
203: “Myanmar Standard Time”;
205: “SE Asia Standard Time”;
207: “North Asia Standard Time”;
210: “China Standard Time”;
215: “Malay Peninsula Standard Time”;
220: “Taipei Standard Time”;
225: “W. Australia Standard Time”;
227: “North Asia East Standard Time”;
228: “Ulaanbaatar Standard Time”;
230: “Korea Standard Time”;
235: “Tokyo Standard Time”;
240: “Yakutsk Standard Time”;
245: “AUS Central Standard Time”;
250: “Cen. Australia Standard Time”;
251: “Adelaide (Commonwealth Games 2006)”;
255: “AUS Eastern Standard Time”;
256: “Canberra, Melbourne, Sydney (Commonwealth Games 2006)”;
260: “E. Australia Standard Time”;
265: “Tasmania Standard Time”;
266: “Hobart (Commonwealth Games 2006)”;
270: “Vladivostok Standard Time”;
275: “West Pacific Standard Time”;
280: “Central Pacific Standard Time”;
281: “Magadan Standard Time”;
284: “UTC+12”;
285: “Fiji Standard Time”;
290: “New Zealand Standard Time”;
295: “Kamchatka Standard Time”;
300: “Tonga Standard Time”;

Advertisements

2 thoughts on “TimeZone field format in CRM

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s