Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music
SOLVED

Converting Date Time

Highlighted
7 - Meteor

I'm having a hard time converting the following date time format. Hoping that someone could assist me.

 

2020-4-26 to Apr20

 

henrymk5_0-1591284968950.png

 

 

Thank you

Highlighted
Alteryx
Alteryx

The DateTime tool should help you to do this using the custom format of Monyy

 

format.png

Highlighted
7 - Meteor

Hi Brandon,

 

It does not match the exact format as my use case.

 

I have 2020-4-27 and your sample is 2020-04-27.

 

Are you still able to resolve using the format from my sample?

 

Thank you !

Highlighted
Alteryx
Alteryx

Yep! Even though your data looks like it is a date, technically it isn't in a date data type yet. You can use one date time tool to format to take your date in a string and convert it into an official date data type, and then use another date time tool to bring it back into a string in whatever format you would like. 

 

format date.png

Highlighted
8 - Asteroid

Hi @henrymk5 ,

Let me know if this works for you.

 

Bennel_Wilson_0-1591288931710.png

 

 

Regards

Benn

 

P.S: In case this solves your query, kindly mark this as a solution.

Highlighted
7 - Meteor

Thank you this works!! I appreciate it

Labels