Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Date format in mmm-yy

mohit9garg
8 - Asteroid

I have date in dd-mm-yyyy format. I want to add a new column to convert the date in mmm-yy which should show the month and year. Also this should be in date format so that it should appear in chronological order in Crosstab (not in alphabetical order).

 

Can someone help me please. Thanks

10 REPLIES 10
mohit9garg
8 - Asteroid

Thanks @Grossal

 

This works. Now I need to create chart on this data. Let me give a try once.

Labels
Top Solution Authors