I have a list of projects with planned start dates. I want to use the JSON field formatter, the documentation to which is here, in order to format the date as 'Year'-Q'quarter'.
I have a calcualted field that does this:
=YEAR([Planned start date])&"-Q"&ROUNDUP(MONTH([Planned start date])/3,0) and it works perfectly.
Doing this does mean that you cannot quickedit the value and have it render as the new value. The documentation seems to suggest there are some options that can posisbly use a lookup on month to return it's quarter for example... but I just can't get my head round the notation needed to make the JSON work.
Can someone please help format dates this way.