In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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

christian_kamaie
5 - Atom

How to extract year and month from date

5 REPLIES 5
martinding
13 - Pulsar

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().

 

martinding_0-1679895642306.png

 

VijayAtMac
5 - Atom

DateTimeFormat function can also be used from formula tool

.datetimeformat.PNG

grazitti_sapna
17 - Castor

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

Sapna Gupta
GlenR
5 - Atom

Hi,

 

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

redah
5 - Atom

Hi Glen,

 

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

Labels
Top Solution Authors