cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Brooke_
Regular Visitor

Date from Dynamics 1 day behind

Hello,

 

I'm struggling with the dates in Flow; I've got a routine that filters records between a dynamic start and end date pulled from Dynamics records using the CDS connector. The filter routine is correct and generates data but the dates it's using are both 1 day earlier than the dynamics record states. 

 

My user timezone is set to utc 00:00 London Lisbon Dublin.

The system is set to UK formats

 

I've tried to convert the date, in both directions UTC to London Lisbon and London Lisbon to UTC , but the base input initially being pulled through is a day earlier than the Dynamics field data

The outputted results are therefore just in a short date format per the requested formatting in the conversion action

 

e.g. Dynamics record states 01/08/2020, Flow states the following:

 

flow.PNG

 

 

 

 

 

 

 

 

 

 

 

 

Does anyone have any suggestions as to how to pull the correct base time?

 

Thanks in advance

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
JohnAageAnderse
Memorable Member
Memorable Member

Hello @Brooke_ 

Could you show us what is the datetime value including the time? Converting between timezones does require the time value to be there, else it is considered to be midnight, time = 00:00:00!

Kind regards, John

View solution in original post

3 REPLIES 3
JohnAageAnderse
Memorable Member
Memorable Member

Hello @Brooke_ 

Could you show us what is the datetime value including the time? Converting between timezones does require the time value to be there, else it is considered to be midnight, time = 00:00:00!

Kind regards, John

v-alzhan-msft
Community Support
Community Support

Hi @Brooke_ ,

 

Do you want to get the date one day after the dynamic date?

I suggest that you should explain more details about the requirement, or just share an example for the requirement so we could better understand you and provide the proper workaround.

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Ah @JohnAageAnderse! That's it, I had thought it being set as date only and therefore midnight would be sufficient.

Having changed the field from Date only to Date Time, whilst leaving the field data at 00:00:00 it's correctly converting the date from 30/06/2020 to 1/7/2020.

 

Thanks for your help 🙂

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (1,312)