MASTER CALENDER

[wonkymeister]

Hi all,

i need to generate a 6 character fiscal year to my master calender script (and i'm struggling)

Our fiscal year starts in August - month 8

and the fiscal YEAR label that i'd like to display - 2018/9

so where the current fiscal year short is 2018 and the month is March i need something like

if(Month(MyDate) => 8 and AddYears(Month(MyDate)+1) <8, MyDate & '/' & Right(MyDate,1)+1

to achieve 2018/9 for the current month as the fiscal year

make sense? Any ideas anyone?

thanks in advance

[dplr-rn · Accepted solution]

Try this

if(Month(OrderDate)>=8
,Year(OrderDate)&'/'&(Num(Right(Year(OrderDate),1))+1)
,Year(AddYears(OrderDate,-1))&'/'&Right(Year(OrderDate),1)) as FiscalYear

[wonkymeister]

works a treat, many thanks!