How to find Current Quarter without using xlsx import?


Is it possible to found the current quarter value without import xlsx file.?

I have try with below scenarios but it is not working.

My current output:

Output value should be display as Q2.

You may use the data format function to get the (numeric) month.
Then you have multiple option to get the quarter, esp.

  • a calculation with if( ${monthNo} =< 4, “Q1”, if(…) ).

Hint: You may always try the (famous) search function of this forum, please, to get answers and examples: e.g. Search results for 'calculate quarter ' - KoboToolbox Community Forum

1 Like