This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
In general, for this you'll want to use a DateTime Tool:
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,