Financial Year

[joeybird]

Hiya

I am using the code shown to render Financial Year as e.g 2013/2014  2014/2015

Year(addmonths(addyears([Order Date],1),-3)) &'/' & Year([Order Date])

when I do I get

2014/2013

2014/2014

2015/2014

2015/2015

appearing in the pane, I have also tried using the code in the master calendar

Year(addmonths(addyears([Order Date],1),-3)) &'/' & Year([Order Date]) as Financial Year and I get the same

I have tried to

Date(Floor("Order Date"))as "Order Date",

to see if it helps and still no joy

please help

[#2 · Accepted solution]

YEAR(ADDMONTHS([Order Date],-3)) & '/' & (YEAR(ADDMONTHS([Order Date],-3))+1)

so up to April, it takes the Financial year as the year before e.g. today would show as 2015/2016

[joeybird]

ta xx it works!!