topic Re: How to create quarters dynamically from particular year in App Development

How to create quarters dynamically from particular year

sruthi19 — Mon, 20 Dec 2021 21:08:46 GMT

Hi All,

I have to create a Quarter field, from year 2017 in below format. I dont have any date field, how can i generate quarters.

Q1-2017,

Q2-2017,

Q3-2017

Q1-2020

Q2-2020

Q3-2020

Q4-2020

MayilVahanan — Fri, 11 Dec 2020 08:57:24 GMT

Try like below

Left(YourDateField, 2) as Quarter

sruthi19 — Fri, 11 Dec 2020 11:06:03 GMT

Hi,

I dont have any date field, i want to generate quarters from Year 2017 by creating a variable.

Quarters:

Q1-2017........Q4-2020

GaryGiles — Sun, 13 Dec 2020 13:45:49 GMT

Depending on how you plan to utilize this field, you could use:

ValueList('Q1-2017','Q2-2017','Q3-2017', . . . .,'Q1-2020','Q2-2020','Q3-2020','Q4-2020')

Or you could use a date function within the Valuelist to create Quarter start dates.