Forum Discussion

Maria_DK's avatar
Maria_DK
Copper Contributor
Jan 10, 2020

Create event in Flow uses wrong time format but only when date is larger than 12

I am having great difficulty with a flow where I have an input date in this format: 'dd-MM-yyyy hh:mm' and I want the flow to create an event on that specific time. I have used this function: form...
Microsoft Flow
Damien_Rosario's avatar
Damien_Rosario
Silver Contributor
Jan 12, 2020

Hi Maria_DK 

 

I'll make some assumptions here as there's some missing pieces to your puzzle.

 

If your date format is already input in the right format (e.g. 14-03-2020) then the expression you use will switch the numbers around to be 03-14-2020 which will give you the error you have seen.

 

 

If the date is captured as MM-dd-yyyy (e.g. 03-14-2020) then your expression will correctly switch it around to dd-MM-yyyy (14-03-2020).

 

 

Based on what you have in the Event body where the date has switched to 03-09-2020, are you sure that this is the same expression as the create event one? It would seem to be formatted as MM-dd-yyyy. Might be worth revisiting the expression for that bit.

 

If you can provide a screen grab of the Create Event, it would help to see what might have gone wrong if the above hasn't helped diagnose the issue.

 

It would also be helpful to know how the date is initially captured, as I suspect the issue is to do with how you capture the date.

 

Best wishes

Damien

Resources