Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Date Conversion

KamenRider
11 - Bolide

Hi,

 

My excel date shows like this format.

 

Date.PNG

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

 

Date2.PNG

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

 

Date.PNG

 Attaching excel for your reference.

 

Thanks,

Kamen

 

 

 

 

 

 

 

14 REPLIES 14
KamenRider
11 - Bolide

HI @DataNath 

 

See snapshot below.. I hope it helps.

 

Screenshot.PNG

 

Thanks,

Kamem

DataNath
17 - Castor

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

KamenRider
11 - Bolide

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

DataNath
17 - Castor

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

Hugo_Miranda
7 - Meteor

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

Labels