web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / What is the best way t...
Customer experience | Sales, Customer Insights,...
Answered

What is the best way to extract data from CRM .

(0) ShareShare
ReportReport
Posted on by EmployeeOcta 6

Hello All Experts,

I need to extract the data from CRM system and give to some other system.

which timezone should i consider for a user that will uniquely identifiable throughout all the systems.

i heard that whenever we need to extract the data from CRM then we need to create a separate user whose timezone is (UTC).

Problem Statement:

There is a difference in time after fetching all the records from the CRM of different users.

Need experts advice on this.

I have the same question (0)
  • Suggested answer
    gdas Profile Picture
    gdas 50,091 Moderator on at

    If you are not aware about specific timezone  where you are sending data ,you should always use UTC standard . In Dynamics 365 all date-time value always stored as  UTC standard in the Database ,each user having specific timezone preference and based on user timezone converts the date-time at the time of retrieve and populate in the UI to avoid  timezone issue. In other words if you know the timezone then converts date-time value to specific timezone from UTC and send to the other system.

  • EmployeeOcta Profile Picture
    EmployeeOcta 6 on at

    Hello Goutam,

    Thanks for your update ,

    I don't know the timezone of the user where i am going to send the data.

    In our current system we have different timezone which are occupied by different user.

    I need to extract data of all the user's , should i go ahead with UTC timezone for these CRM users as well?

  • Verified answer
    gdas Profile Picture
    gdas 50,091 Moderator on at

    yes  use UTC  , so that integrated system can convert the date-time with their timezone.

  • EmployeeOcta Profile Picture
    EmployeeOcta 6 on at

    Thanks for the advice , i will mark this as answer for getting the data into UTC format.

    whether tat will work on other different system or not i am not sure so i will mark it as really helpful.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 170 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 155

#3
CU11031447-0 Profile Picture

CU11031447-0 100

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans