Forum Discussion
Calendar Fiscal Quarter Offset M Code for Function
Hi Community! I have a calendar function and I need to work out how to get the Fiscal Quarter Offset. I understand I need the current date to extract the current fiscal year but I can't work out ...
Hi v-chuncz-msft,
Could you elaborate how Date.AddMonths will work in my situation?
Our fiscal year ends in October, so from
Nov-Jan = Q1
Feb-Apr = Q2
May-Jul = Q3
Aug-Oct = Q4
For instance, we are currently in March 2020, so
Feb 2020's FiscalQtr Offset = 0;
Jan 2020's FiscalQtr Offset = -1;
Dec 2019's FiscalQtr Offset = -1;
Nov 2019's FiscalQtr Offset = -1;
Oct 2019's FiscalQtr Offset = -2;
Sep 2019's FiscalQtr Offset = -2;
...
...
Jun 2019's FiscalQtr Offset = -3....