Alteryx Designer Desktop Discussions

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

Help! DateTime tool give me Nulls results

OscarCuevas
6 - Meteoroid

Hi I need your help, when I use the DateTime tool to converse V_string type to Date type in this format dd/mm/yyyy but the results that give me are Nulls, I dont know why, can you help me?

 

Thanks

 

The data that I need to converse

OscarCuevas_0-1586189282158.png

The DateTime tool configuration

OscarCuevas_1-1586189417571.png

The results

OscarCuevas_2-1586189513543.png

 

2 REPLIES 2
Blake
12 - Quasar

Hi @OscarCuevas  - your dates are already in the preferred Date/Time format. If you want them in the MM/dd/YYYY format, change the radio button at the top of the tool to "Change Date/time format to string" and it will output what you want. 

 

Blake_1-1586190106030.png

 

 

Let me know if this works for you. 

OscarCuevas
6 - Meteoroid

Ohh you´re right,  I added a Select tool  and change the data type to Date and then use the Datetime tool

 

thanks

 

OscarCuevas_0-1586191577964.png

 

 

 

OscarCuevas_2-1586191676647.png

 

 

 

OscarCuevas_1-1586191620333.png

 

 

 

OscarCuevas_3-1586191790886.png

 

 

Labels