Getting wrong date value from Microsoft Dynamics 365 CRM

Like (0) Share

Report

Posted on 28 Apr 2020 10:01:13 by waleedbinafzal

Hi,

I have a flow that runs everyday to check if there are any task with due date today to send a reminder email to the user. The flow works fine. The only issue which I am facing and have no idea why it happening. The issue is if the due date of the task in Dynamics 365 CRM is April 24, 2020, when I get the data in Microsoft Flow, this date value will turn into April 23, 2020 which is quite strange. I have no idea why it is subtracting one day automatically from the date field while getting the data from Dynamics 365 CRM.

Please help.

Thanks,

Waleed.

I have the same question (0)

All responses (3)

Answers (0)

JeganathanG 50 on 13 Mar 2023 at 06:00:32

Like (0)

Report

Re: Getting wrong date value from Microsoft Dynamics 365 CRM

Hi @WaleedBinAfzal ,
I also have the problem that the date I work on will be one day off from the actual date,I'm using a document update remainder flow that sends an email once a week.

The main reason is that the system local time and the login email time zone are different.

1. This is my System Time01

2. This is my Login Email Time Zone

02

3. Changed Login email time zone

After changing the time zone on both the system and the login email, the problem was resolved, and the date now updates correctly.

Thanks,
Jegan

Was this reply helpful? Yes No
MJain 2,450 on 12 May 2020 at 21:46:35

Like (0)

Report

Re: Getting wrong date value from Microsoft Dynamics 365 CRM

Hi @WaleedBinAfzal ,

Additionally you have to make sure that the timezone which you are running your recurring job matches with your user when you query data in CRM

Thanks

Was this reply helpful? Yes No
Ed Gonzales 4,531 Most Valuable Professional on 12 May 2020 at 21:33:48

Like (0)

Report

Re: Getting wrong date value from Microsoft Dynamics 365 CRM

@WaleedBinAfzal

The date you are seeing through your D365 front-end is corrected for your local timezone based on your personal settings. It is stored, however, in UTC. If you add a step after it fetches the date called "Conver time zone" to change from UTC to your local, the dates should match.

Please keep us posted.

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Was this reply helpful? Yes No