How to find Current Quarter without using xlsx import?

User Support Form Building
, ,
1

Hello,

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

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

image
image1187×205 6.48 KB

My current output:

image
image1029×67 2.85 KB

Output value should be display as Q2.

2

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