Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Every one,
My fisacal year starts from ever year 26 th march .
How to create a fiscal year for this ?
Thanks,
Bhargav
Please use the below script to get the fiscal year
if(Month(Date_cloumn)>3,year(Date_column)&' to '&year(Date_column)+1,
if(Month(Date_cloumn)<3,year(Date_column)-1&' to '&year(Date_column),
if(Month(Date_cloumn)=3 and Date(Date_column,'DD')<=25,
year(Date_column)-1&' to '&year(Date_column),
year(Date_column)&' to '&year(Date_column)+1
))) as Fiscal_Year
Please use the below script to get the fiscal year
if(Month(Date_cloumn)>3,year(Date_column)&' to '&year(Date_column)+1,
if(Month(Date_cloumn)<3,year(Date_column)-1&' to '&year(Date_column),
if(Month(Date_cloumn)=3 and Date(Date_column,'DD')<=25,
year(Date_column)-1&' to '&year(Date_column),
year(Date_column)&' to '&year(Date_column)+1
))) as Fiscal_Year