community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Excel Column Date Format

Asteroid

Hi Guy's,

 

I have an excel file with Date Column coming in format "dd-mmm-yyyy" Ex : "01-Jan-2018".

 

When i import it in alteryx using input data tool showing data type as V_String.

 

In next step i am trying to convert it into DATE Format by using Select tool. But alteryx making all the rows null. 

 

So, Please let me know, is there any way to handle it ?

 

I have attached the sample file, please refer "Testing Date" column.

Alteryx Partner

In general, for this you'll want to use a DateTime Tool:

weirddateformat.PNG

 

 

Set the DateTime Tool format to "dd-Mon-yyyy" and you'll be good to go.

 

When using the Select Tool, Alteryx is setting them all to Null() because it doesn't recognize that as a proper DateTime object. In Alteryx, Dates are ALWAYS given in yyyy-mm-dd format.

 

Let me know if this helps,

 

Cheers!

Labels