How to extract month and year from a date?

[bjemison]

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?

[linda_rydalv]

You could use the DateTime tool from the Parse section.

Select Custom and type dd-Mon-yy.

[Alteryxexpert]

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

[CharlieS]

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")