Convert a date to a Month/year

I am storing a date DD/MM/YYYY but I would like to store this in another field as MM/YYYY so I can group/count values by month. Is this possible, what would be the best way to do this. I am constantly adding new dates so it need to be dynamic. Thanks.

Please try expression in the MonthYear column something like

TEXT([Your Input Date Column], “MM/YYYY”)

Assumes [Input date column] has dates in DD/MM/YYYY format.

3 Likes

Thank you. The expression is working. I created a virtual column to store this data.

2 Likes