Date Conversion not working

[George_Fischetti]

Hi folks - I'm trying to convert a date in my workflow that is coming from an Excel source as 20210501.   Alteryx is bringing the field in a a V_String.   

I was trying to use a formula tool with the ToDate() function but my output is coming out Null.  Is there a better way to handle this?

Thanks!  George

[Garabujo7]

Hello @George_Fischetti ,

There is a way easier way to do it:

The DateTime block, that it in the parse category.

Also you could look into the one tool example to see how it is used.

Here are the options:

Hope this helps.

[Luke_C · Accepted solution]

Hi @George_Fischetti 

Here's two different approaches, one with the datetime tool mentioned above, and one with the date time parse function.

I suggest bookmarking this page, it is invaluable when working with dates and alteryx date functions: DateTime Functions | Alteryx Help

[George_Fischetti]

Thank you both for your input - the formula tool with the datetimeparse function worked best!!!

[Tyro_abc]

Hi

Try this...