Chaque semaine, découvrez de nouvelles astuces et bonnes pratiques pour devenir un expert !
Voir l'indexHello,
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
Résolu ! Accéder à la solution.
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:
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
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 ?
Good tip !! I am checking it. thank you