Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
ta xx it works!!