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

[Hugo_Miranda]

Kamen, 

You'll need to convert your input to a Datetime data type to preserve the incoming date format. You can do this using a Select Tool.

Hope this helps.

__PRESENT

[KamenRider]

Hi @Hugo_Miranda 

The problem is that there is no DateTime or Date data type in the selection.

Kamen

[DataNath]

@KamenRider, use the following Formula expression:

ToDateTime([ASOFDATE])

[shancmiralles]

hi @KamenRider .. your file is in xlsx and when i download it it shows me YYYY-MM-DD part of your data in alteryx.. however.. the format changing when fed to alteryx we had that.. i change the file from xlsx to csv...  not sure if it will work for you but worth the shot. goodluck!! :)

[KamenRider]

Hi @DataNath 

Got this error:

 

Please advise.

Kamen

[KamenRider]

Hi @shancmiralles 

Thanks for your response however, converting it to csv is not a requirement. It should be in xlsx format.

Kamen

[DataNath]

@KamenRider check your other expressions. That error is linked to your first expression as stated - you're not using a '+' and don't have 50 characters in the expression you're showing. 

[KamenRider]

Hi @DataNath 

I'm sorry but I can't the reason of the error. I don't special characters in the formula and I am a kind of confuses why using + sign.

Please advise.

Kamen

[DataNath]

@KamenRider can you show your full screen including all expressions etc?