Alteryx Designer Desktop Discussions

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

How to extract year and month from date

5 REPLIES 5

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

You can also use DATETIMEFORMAT().

DateTimeFormat function can also be used from formula tool

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

Sapna Gupta

Hi,

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

Hi Glen,

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

10 KB