Create a new column for YEARS

[Disey]

Hi

I am trying to create a new column for some data which has a number of months/years in it's own column and I want to create a new column to represent the financial years for this data. eg: 

YEAR_MONTH
201912
201810
201810
202002
201904
201908
201806
202002
201907
201811
201805
201912
201906

I want an extra column showing : 

YEAR

2018/19

2019/20 etc

the Year Month column is currently  'Int32' if this helps

thanks

[binuacs]

@Disey one way of doing this

[Disey]

Thank you but I need the financial year ie: 2018/19, 2019/20, 2020/21 etc, this example works when i try it but it has the month after the / which is also in your example and I need the year .

[binuacs · Accepted solution]

@Disey here you go

[Disey]

Perfect, it worked,thank you 😃  I would never have fathomed that out myself 🤷‍

[DavidSkaife · Accepted solution]

Hi @Disey 

If your financial year runs April to March then try this:

[Disey]

thank you, this is perfect for financial years