Create a new column for YEARS

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

Datasets

Accepted answers

binu_acs

@Disey here you go

Year_04032025.yxmd

davidskaife

Hi @Disey

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

Financial Year.yxmd

All comments

binu_acs

@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 .

binu_acs

@Disey here you go

Year_04032025.yxmd

Disey

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

davidskaife

Hi @Disey

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

Financial Year.yxmd

Disey

thank you, this is perfect for financial years

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335