Date from Dynamics 1 day behind

[Brooke_]

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:

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

Thanks in advance

[JohnAageAnderse · Accepted solution]

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]

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.

[Brooke_]

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 🙂