Get indian financial year

[sunil_prajapati]

hey everyone

need a financial year in the formate of 2020-2021 from [date] column

financial year start and end from 01/04/2020 to 31/03/2021

this should be in a single columm.

i have tried this but didnt works

IF(and([date]>=DATE(CONCATENATE(“4/1/”,YEAR(TODAY()))),[date]<=DATE(CONCATENATE(“3/31/”,YEAR(TODAY()+1)))),year(today())&"-"&year(today()+1),"")

[LeventK]

@sunil_prajapati
Your expression is symantically not correct. Try with this:

IF(
	AND(
		[date]>=DATE(CONCATENATE(“4/1/”,YEAR(TODAY()))),
		[date]<=DATE(CONCATENATE(“3/31/”,YEAR(TODAY())+1))
	),
	YEAR(TODAY())&"-"&YEAR(TODAY())+1,
	""
)

[sunil_prajapati]

hello sir

thanks for the quick reply will try and revert back to u soon.

[sunil_prajapati · Accepted solution]

really thanks a lot… sir…

that works fine just I made one change due to a result correction. its sawing result 2020-20201
so i made one change in expression. first result.
IF(
AND(
[date]>=DATE(CONCATENATE(“4/1/”,YEAR(TODAY()))),
[date]<=DATE(CONCATENATE(“3/31/”,YEAR(TODAY())+1))
),
YEAR(TODAY())&"-"&YEAR(TODAY()+365),
“”
)

if I add an old year entry then the result is empty as per this expression now is it possible to get the previous date financial year instead of blank. like if today is 12/12/2020 and I want to add an entry of 31/03/2020 dd/mm/yyyy then expression should saw 2019-2020.

GOT IT FOR EVEN OLD AND FUTURE ENTRIES!

IF(
AND(
[date]>=DATE(CONCATENATE(“4/1/”,YEAR([DATE]))),
[date]<=DATE(CONCATENATE(“3/31/”,YEAR([DATE])+1))
),
(YEAR([DATE])&"-"&YEAR([DATE]+365)),(YEAR([DATE]-365)&"-"&YEAR([DATE]))
)