topic Financial Year in App Development

Financial Year

joeybird — Mon, 07 Mar 2016 12:22:16 GMT

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

Mon, 07 Mar 2016 12:28:08 GMT

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 — Mon, 07 Mar 2016 14:42:19 GMT

ta xx it works!!