topic Quarter creation based on Friday in App Development

Quarter creation based on Friday

prakashij_25 — Thu, 15 Jul 2021 09:25:08 GMT

Team,

I have a requirement of creation customized Quarter field based on Date field. All Quarter should have 13 weeks and last week of Quarter should end with Friday. Also we are considering only Network days

Q1 2021-Started-01/04 ended with 04/02

Q222021 - Started - 04/05 ended 07/02

Q3 20201- Started - 07/05 ended 10/01

Q4 2021 - started - 10/04 ended 12/31

Any idea will be highly appreciated

Re: Quarter creation based on Friday

Gysbert_Wassenaar — Wed, 14 Jul 2021 10:46:48 GMT

Create your calendar in an excel file with quarters for the next ten (or more) years. Then load the calendar from the excel file.

Re: Quarter creation based on Friday

prakashij_25 — Wed, 14 Jul 2021 14:00:01 GMT

Hi,

Thank you for your kind reply. However it wont work in that way