Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Answered

What are the Time zone references/values when doing Event (webinars, fairs, etc) Bulk import?

(0) ShareShare
ReportReport
Posted on by 84

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?

  • ChadAlt Profile Picture
    ChadAlt 367 User Group Leader on at
    RE: What are the Time zone references/values when doing Event (webinars, fairs, etc) Bulk import?

    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! :)

  • Suggested answer
    Helene B. Profile Picture
    Helene B. 84 on at
    RE: What are the Time zone references/values when doing Event (webinars, fairs, etc) Bulk import?

    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.

    https://microsoft-business-applications.hcltech.com/crm-101/importing-values-time-zone-fields-dynamics-crm/

    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!

  • Verified answer
    ChadAlt Profile Picture
    ChadAlt 367 User Group Leader on at
    RE: What are the Time zone references/values when doing Event (webinars, fairs, etc) Bulk import?

    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. 

    pastedimage1661168594490v1.png

    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!

    pastedimage1661169102098v2.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,160 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans