Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community
Can anyone please assist me , I am building a calendar with a switch between fiscal and Normal calendar . The requirement For the Fiscal Calendar is that the Year starts on July and End June on the following Year , So the Issue is that when we reach December , it doesn’t go on and pick January as my July it stops in December . On the Attached Screenshot I selected 2015 , it ends on 201606 which is December so I want it to even go to 201607 which is January on the normal Calendar etc. .
num((if(Month(ArTrnDetail.InvoiceDate) > 6 , year(ArTrnDetail.InvoiceDate)+1))&num(if(Month(ArTrnDetail.InvoiceDate) > 6 , Month(ArTrnDetail.InvoiceDate) - 6),'00')) AS Fin_YEAR_MONTH,
num((if(Month(ArTrnDetail.InvoiceDate) > 6, year(ArTrnDetail.InvoiceDate)+1)-1)&num(if(Month(ArTrnDetail.InvoiceDate) > 6, Month(ArTrnDetail.InvoiceDate) - 6) ,'00')) AS Fin_YEAR_MONTH_PREVIOUS,
Chech the code given by jagan here: Fiscal and Standard Calendar generation