Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Getting wrong date value from Microsoft Dynamics 365 CRM



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. 




Super User II
Super User II

Re: Getting wrong date value from Microsoft Dynamics 365 CRM


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.




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.

Solution Specialist
Solution Specialist

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





Helpful resources


August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!


Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (3,299)