Display a financial quarter - Q1,2,3,4

The time/date fields allow the display of the Calendar year quarter (Q1, 2, 3, 4). Is there any way to display the financial quarter?

For example in the UK Q1 financial quarter is April-June. Ideally it would be great to be able to set an artitrary financial year start date set the quarters to run from that, but I cannot see a way to do this.

If you only want to show text like Q1 Q2 Q3 Q4 for any whole calendar month, then you could place for example 4 text fields or images on same spot and manage their visibility using expressions for opacity like this: (([M]==4)+([M]==5)+([M]==6))*100. This will show any element during month 4, 5, 6. Put your desired month numbers in every one of the 4 elements.

1 Like

Wow! Fantastic. Tag expressions had completely passed me by. Your suggestion will do the trick nicely.

Many thanks Peter :slight_smile:

Rob