communauté
annuler
Affichage des résultats de 
Rechercher plutôt 
Vouliez-vous dire : 

Forum - Français

Trouvez des réponses, posez des questions, et partagez votre expertise d’Alteryx.
RÉSOLU

HELP : blocking Issue to convert a date

Highlighted
Atome

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).

 

clipboard_image_2.png

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:

 

clipboard_image_3.png

 

We were converting it to dd/mm/yyyy 

clipboard_image_1.png

clipboard_image_0.png

 

But we are receiving following error afterwards:

clipboard_image_4.png

 

I also tried DateTimeParse:

clipboard_image_6.png

And i face the following error:

clipboard_image_7.png

 

Thank you for your support

Quasar

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

Atome

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

 

clipboard_image_1.png

clipboard_image_0.png

 

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

 

clipboard_image_2.png

 

clipboard_image_3.png

Quasar

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

Atome

Good tip !! I am checking it. thank you