HELP : blocking Issue to convert a date

[Greg49]

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]

hi @Greg49,

in your cas,e you use the french date format, for alteryx, it is a string and not a date, to have it as a date you must transform it, ther eyou have 3 possibilities:

• use a datetime tool which will create a new field and create a date base on the field you want to transform
• use a formula tool and the formula datetimeparse to transform it into a date
• use a multi_field formula to change the time + a datetimeparse formula

The only thing is if you have multiple formats in one column, then you could use regex or filters to apply you treatment.

Find attached a sample workflow

if you want further help, could you provide some sample data?

Hope it helped

[Greg49]

Hello Ladarthur,

That's exactly what i was doing originally during several weeks. I mean i was converting it with Convert Date dd/MM/yyyy

But as i mentionned i received the error message shown in my original message.

Then i also tryed the dateTimeParse formula... in vain. With the second error message below

Any suggestion ... what could be the root cause ?

[Ladarthure · Accepted solution]

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 solution]

Good tip !! I am checking it. thank you