Free Trial

Alteryx Designer Desktop Discussions

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

How do I find the largest month in a given list of dates and convert it to “YYYY-MM”?

phoebe_90
8 - Asteroid

I have a list of dates; how can I design the workflow to find the date of the largest month and change it into “YYYY-MM”?

For example, from below data list to find 2024-10-18, and change it to 202410.

Booking Date
2024-08-22
2024-08-29
2024-08-29
2024-09-09
2024-08-29
2024-09-18
2024-09-18
2024-10-18
1 REPLY 1
flying008
15 - Aurora

Hi, @phoebe_90 

 

FYI.

 

录制_2024_11_15_15_09_42_842.gif

Labels
Top Solution Authors