Date Conversion

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

Workflow

Date Time

Accepted answers

All comments

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

Hi @Hugo_Miranda

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

Kamen

@KamenRider, use the following Formula expression:

ToDateTime([ASOFDATE])

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!!

Got this error:

ERROR DATE.PNG

Please advise.

Kamen

Hi @shancmiralles

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

Kamen

@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.

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

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

See snapshot below.. I hope it helps.

Thanks,

Kamem

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

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

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

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

Quick Links

Tags

This months top contributors

AkimasaKajitani 388

Hollingsworth 335