In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more 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