Date Conversion

[KamenRider]

Hi,

My excel date shows like this format.

But when I run it in Alteryx it shows like this in VWString format. 

 

Tried using the date tool but it gives me a NULL value. Can someone help me please on how to convert it this type of format

 Attaching excel for your reference.

Thanks,

Kamen

[KamenRider]

HI @DataNath 

See snapshot below.. I hope it helps.

Thanks,

Kamem

[DataNath]

@KamenRider can you show your Formula configuration with the incoming data as well?

[KamenRider]

Which part @DataNath ? What tool in my workflow please?

[DataNath]

The Formula tool where you're treating [ASOFDATE], with all expressions open so we can see what you're doing

[Hugo_Miranda]

@KamenRider In your formula for DATE1, change your Data Type (bottom drop down) to DateTime. It's currently set as a V_WSTRING (default).