Thanks, that’s resolved the how to get the year piece.
I’m now stuck again as dates in postgre seem to behave differently
to_char(t.created_at, ‘MM-YY’) as Yearmonth,
This is giving me 10-22 which represents “Oct-22”
How am I able to change 10-22 to Oct-22? I have tried to look at guidance within discourse but not been able to find this, unless I’m not sure where to look?
Thanks