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.
Thank you. The expression is working. I created a virtual column to store this data.