Date Error Resulting to Null Values

crazybeauti_ful

Hello,

I've attached the actual date sample that I've been working on. Basically, the dates are in yyyymmdd format (i.e. 20200414). I need them in 2020-04-14 date format. Alteryx initially reads them as V_String. I found a similar case here and thought this will solve my problem - https://community.alteryx.com/t5/Alteryx-Designer-Discussions/yyyymmdd-to-dd-month-yyyy-conversion/td-p/12782 

but using the actual formula in the link gives me 2020-01-01 or 2020-12-12 or 2020-03-03 not the actual days. So I edited the substring syntax with the following --

DateTimeFormat(LEFT(tostring([Date 1]),4)+'-'+SUBSTRING(tostring(Date 1]),5,2)+

'-'+SUBSTRING(tostring([Date 1]),7,2),'%Y-%m-%d') but this gives me a null value due to a conversion error (also in the attached - date error).

I tried all other things that  I could find online but all of them gave me null values.

Help please.

Thank you.

Date Sample.xlsx

date error.PNG

fmvizcaino

Hi @crazybeauti_ful ,

I suggest you to use the datetime tool to do that conversion automatically.

Let me know what you think about it.

Best,

Fernando Vizcaino

2020-04-13 Date Error Resulting to Null Values.yxmd