Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I currently have the following calculated field 'Q' & Ceil(Month([Activity Month])/3) &' '& 'FY'&((Year([Activity Month]))+1) which purpose is to show the data in the following way Q1 FY18 or FY19 according to the year but instead it's showing as FY2018 or FY2019 i need the best way of converting the year from YYYY to YY so it could show as FY18 or FY19 depending on what is shown on the Activity Month Table.
May be this
'Q' & Ceil(Month([Activity Month])/3) &' '& 'FY'& Right(((Year([Activity Month]))+1), 2)
May be this
'Q' & Ceil(Month([Activity Month])/3) &' '& 'FY'& Right(((Year([Activity Month]))+1), 2)
Thanks for the assistance
I also need the Q to start in April which will be month #4 is there any solution which could be applied on the calculated field in the same function above??
May be this
'Q' & Ceil(Month(AddMonths([Activity Month], -3))/3) &' '& 'FY'& Right(((Year(AddMonths([Activity Month], -3)))+1), 2)
Or this
'Q' & Ceil(Month(AddMonths([Activity Month], 9))/3) &' '& 'FY'& Right(((Year(AddMonths([Activity Month], 9)))+1), 2)