topic Re: Calculate Fiscal Year Flags on Master Calendar in App Development

Calculate Fiscal Year Flags on Master Calendar

micheledenardi — Fri, 22 Sep 2017 07:24:03 GMT

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

Gysbert_Wassenaar — Fri, 22 Sep 2017 07:51:05 GMT

Try the InYear and InYearToDate functions.

InYear(Date. Today(), 0, 6)

InYearTodate(Date, Today(), 0, 6)

siddharth_kulka — Wed, 22 May 2019 20:48:09 GMT

Found an excellent post which was very useful for me.