Forum Discussion
Create event in Flow uses wrong time format but only when date is larger than 12
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