web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums 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) Share

Report

Report

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)

All responses Img

All responses (4)

Answers Img

Answers (1)

Suggested answer

gdas 50,091 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
EmployeeOcta 6 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

gdas 50,091 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No
EmployeeOcta 6 on at

Like (0)

Report

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.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1

Tom_Gioielli 170 Super User 2025 Season 2

#2

#3

Gerardo Rentería Ga... 52 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans