Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

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

How to extract month and year from a date?

bjemison
7 - Meteor

I would like to convert a date field to month-year (e.g. convert 03-25-2019 to March-2019, or Mar-2019, or 03-2019, the format isn't really important to me.) I know that I can extract the year and the month from a date by using Datetimeyear() and Datetimemonth() respectively but what if I want to extract both?

12 REPLIES 12
linda_rydalv
Alteryx Alumni (Retired)

You could use the DateTime tool from the Parse section.

Select Custom and type dd-Mon-yy.

Alteryxexpert
8 - Asteroid

@CharlieS is it possible to extract Reformat as Mar-19 , your workflow extracts as March-2019.

CharlieS
17 - Castor
17 - Castor

Of course. You just need to change the "%B" (which gives you "March" to "%b" which gives you the abbreviated month name of "Mar". Also swap "%Y" for "%y" to output "19" 

DateTimeFormat(DateTimeParse([Input],"%m-%d-%Y"),"%b-%y")

Labels