Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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