Date formatting

[LoisGower]

Hey team,

Can you please help, having a mare with this one! - i've tried using the community to get to the answer and it's just not working 😞

This is the date format i'm getting when I use the Date Time too in Parse 

I'd like the data to read like 07 Aug 2013

If anyone knows how to do this, please let me know!

Many thanks,

Lois.

[atcodedog05 · Accepted solution]

Hi @LoisGower 

Your configuration should be something like to get as 07 Aug 2013

Hope this is what you are looking for

Hope this helps 🙂

[Emil_Kos]

Hi @LoisGower,

Not sure if you are aware but you will need to have this data in a string format.

This is the formula you need to use:

DateTimeformat([DateTime_Out],'%d %b %Y')

I have also attached a workflow for you. 

[LoisGower]

oh my god thank you so so much for this 🙂 - it worked, thank you!!!1

[LoisGower]

Thanks for this, it's good to know, i'll also try this one out too!

Thank you everyone for such quick responses - really appreciate the help!

[Emil_Kos]

Hi @LoisGower,

The dates in Alteryx needs to be in one format. If you want to get a different format you can use a date-time tool or formula tool to transform it into a string,.