Hi community,
We are importing events in Marketing 365 and one of the column for the Excel Template for Bulk import is Time Zone. The tooltip indicates values between -1500 to 1500 and I cannot find which timezones it corresponds to so my events in Sweden are set to Hawaii and Finnish one to Alaska.
Do you know where I can find table with the correspondances?
Ah, good find! Well now we know a couple of methods. The URL I showed above should work for you, as well, but that table looks to suffice.
Glad you got it!
If you wouldn't mind, would you mark my solution as helpful?
Thanks! :)
THANKS! Nice you took the time to look into it.
After I posted this question I went back and kept trying to find a logic and a bit further research until I found a chart with the values which are not guessable easily.
According to your screenshot you have access to the portal power apps which sadly i don't but now I know i could have found it there too.
Definitely not straightforward!
Shoot, I thought this was an easy question, but it's not so simple. We can see that this column is a whole number type of "Time Zone" format. I also found there is a hidden table called timezonedefinitions, and it seems this is the key for you.
By running the below query, you can get a JSON output of all the time zones and their timezonecode values.
https://yourorg.crm.dynamics.com/api/data/v9.2/timezonedefinitions
After parsing out the JSON response, I can see an example of timezonecode 5 for Pacific Standard Time, which aligns to an event I'm looking at. Perhaps there's an easier way to find this, but this should get you there!
André Arnaud de Cal...
292,160
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156