Hey @jasminesang
Can parse the date with a formula tool - the %B character returns just the month.
Here is an example 🙂
Updated: Add new flow with text month instead of number.
@jasminesang
A simple DateTimeParse would do as well assuming the dates are in Date format
Hi. What if I have a date like 01/27/2022 and I want to summarize data by month and years so in the chart I am able to see the years and the months?
Thanks
@tosinico
You can first convert your date to yyyy-mm-dd format
And then follow the same as above and add a year as well
You can find all the different date formats available herehttps://help.alteryx.com/20223/designer/datetime-tool#custom-format
@MichalM thanks!
