Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

V_String to Date conversion

EN6924
10 - Fireball

I have a data -

 

Datatype of column "Date_Added" is - "V_String"

 

When I try to convert it, it's showing NULL. I want to convert it so that I can add a range formula later.

 

EN6924_0-1642064845733.png

 

Need help.

 

 

 

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @EN6924 

 

In the tool you are expected to apply the incoming format like below.

 

Workflow:

atcodedog05_0-1642065259109.png

 

Hope this helps : )

 

binuacs
20 - Arcturus

@EN6924 Another option if you are not sure about the format just use the custom format 

 

binuacs_0-1642065718676.png

 

EN6924
10 - Fireball

Thanks.. I got the idea now. 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @EN6924 

Cheers and have a nice day!

Labels