We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Excel Date data in general Format convert date in alteryx

arjundelara
8 - Asteroid

Hi All,

 

Having a date format with general format.

 

arjundelara_0-1608527502266.png

The [F4] field is a string. I'm working to set it on a date format in alteryx.

 

anyone can help me to set the date so it'll be captured in alteryx.

 

TIA.

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @arjundelara 

 

This is the format you need to use

dd Month yyyy

 

Workflow:

atcodedog05_0-1608534318657.png

Hope this helps 🙂

arjundelara
8 - Asteroid

Hi @atcodedog05 ,

 

This is the simplest solution I get!. I've created a many tools to get the output like this :3

 

Thank you so much !

 

Cheers,

Labels
Top Solution Authors