Hello experts,
i want to add to my master calendar some fiscal year flags.
My fiscal year start on month 7 (July) so i have to calculate a
1) CurrentFiscalYearFlag so that each date between 01/07/2017 and 30/06/2018 is set to 1, otherwise 0.
2) CurrentFiscalYearToMonthFlag so that each date between 01/07/2017 and the month of current date is set to 1, otherwise 0.
If today is 22/09/2017 i want to obtain exactly this result:
| Date | CurrentFiscalYearFlag
| CurrentFiscalYearToMonthFlag |
|---|
| 01/07/2017 | 1 | 1 |
| 30/06/2018 | 1 | 0 |
| 01/07/2018 | 0 | 0 |
| 30/06/2017 | 0 | 0 |
| 22/09/2017 | 1 | 1 |
| 23/09/2017 | 1 | 1 |
| 30/09/2017 | 1 | 1 |
| 01/10/2017 | 1 | 0 |
thanks
Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
