Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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