HELP : blocking Issue to convert a date

Question

Hello,

i am facing a blocking issue while trying to convert export date. After a first workflow my Export date appears as follow (dd/mm/yyyy).

Yet i am already surprised that it is not considering this date as the maximum (as it should be) but the one of last week:

We were converting it to dd/mm/yyyy

But we are receiving following error afterwards:

I also tried DateTimeParse:

And i face the following error:

Thank you for your support

Ladarthure · Accepted Answer

I see you ahve one date in a proper format (yyyy-MM-dd) what may work is to use a filter on your field date with the one containing " / " and the one containing " - " and then do 2 different treatments, finally union the whole data and use the results.

Attached an example

Greg49 · Accepted Answer

Good tip !! I am checking it. thank you