How to found quarter with the help of between date

sudarshan · July 3, 2023, 4:44am

Hi,

Can we add here custom date to find the quarter?

Eg.
01-01-2023 between 15-04-2023 = Q1.
16-04-2023 between 15-06-2023 = Q2.
16-06-2023 between 15-09-2023 = Q3.
16-09-2023 between 31-12-2023 = Q4.

Thanks,

sudarshan · July 3, 2023, 4:52am

Hi,

How to find quarter with the help of custom date
Eg.
01-01-2023 between 15-04-2023 = Q1.
16-04-2023 between 15-06-2023 = Q2.
16-06-2023 between 15-09-2023 = Q3.
16-09-2023 between 31-12-2023 = Q4.

Thanks,

Kal_Lam · July 3, 2023, 5:39am

@sudarshan, you should be able to do it as outlined in the image shared below:

In the survey tab of your XLSForm:

Data entry screen as seen in Eneko (when nothing is entered):

Data entry screen as seen in Eneko (when a date from Q1 is selected):

Data entry screen as seen in Eneko (when a date from Q2 is selected):

Data entry screen as seen in Eneko (when a date from Q3 is selected):

Data entry screen as seen in Eneko (when a date from Q4 is selected):

Reference XLSForm:

Quarter from Dates.xlsx (10.1 KB)