Change list of dates to a month

[wonka1234]

Hi,

How can I change my list of dates throughout the year to the month only?

Date	Count
12/31/2022	1
12/30/2022	2
12/29/2022	3
12/28/2022	4
12/27/2022	5
12/26/2022	6
12/25/2022	7
12/24/2022	8
12/23/2022	9
12/22/2022	10
12/21/2022	11
12/20/2022	12
12/19/2022	13
12/18/2022	14
12/17/2022	15
12/16/2022	16
12/15/2022	17
12/14/2022	18
12/13/2022	19
12/12/2022	20
12/11/2022	21
12/10/2022	22
12/9/2022	23
12/8/2022	24
12/7/2022	25
12/6/2022	26
12/5/2022	27
12/4/2022	28
12/3/2022	29
12/2/2022	30
12/1/2022	31

to

2022-12  496

This would need to be repeated for any month.

Thanks.

[JamesCharnley]

@wonka1234  a couple of date calculations can do this one for you, parse and format.

To fully match your output you can then just summarize

[binuacs]

@wonka1234 one way of doing this

[wonka1234]

@JamesCharnley  what if my date format is '2021-08-31' and a string? I am getting null using your formula.

[MilindG · Accepted solution]

[JamesCharnley]

@wonka1234  I did my DateTimeParse formula to match your given input (with the slashes). If your date is a string in another format you need to change the parameter to match it, whatever it is. Though your example is the correct ISO format for Alteryx (yyyy-mm-dd)