How to extract year and month from date

[christian_kamaie]

How to extract year and month from date

[martinding]

Hi @christian_kamaie ,

There are many ways to achieve this, the easiest is to make use of the DATETIMEYEAR(), and DATETIMEMONTH() functions.

You can also use DATETIMEFORMAT().

[VijayAtMac]

DateTimeFormat function can also be used from formula tool

.

[grazitti_sapna]

Hi @christian_kamaie 
I Have made a workflow for use case .
Hope it works for you. Kindly Check.
Thanks & Regards

[GlenR]

Hi,

Thank you for this response it has worked for me. Does alteryx have YYYY-mmm function e.g 2024-Mar.

[redah]

Hi Glen,

Try DateTimeFormat([calendar_date], '%Y-%b'). See attached.