ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
RÉSOLU

Joining field to create a date

Jaloy_1973
Astéroïde

Hi Community,

 

I have 3 V_String fields, corresponding to the day, month and year. of a dataset.

I would like to concatenate them to transform then into a date with the DateTime tool.

I assume it must be easy but I can't figure out how to join the three fields?

 

Thanks a lot!!!

 

Jordi

 

 

 

4 RÉPONSES 4
binu_acs
Polaris

@Jaloy_1973 One way of doing this

image.png

Manoj_k
Boule de feu

I tried a different method where you concatenate the string field and then convert them to date using date time tool 

Jaloy_1973
Astéroïde

Really appreciated.

It worked perfectly.

 

Jordi

Jaloy_1973
Astéroïde

Many thanks, it worked too.

 

Jordi

Étiquettes
Auteurs des meilleures solutions