Solved: RE: Extract Year from YearMonth

Anonymous · ‎02-05-2019

Hi all,

i have Month filed coming from Database like below.

Month

201809

201810

201811

201812

201901

201902

like so on.... from this i need to extract Month as seperate field,year as seperate field

how to achieve this?

Best

Chanty

Zubair_Muhammad · ‎02-05-2019

@Anonymous

You can use same function like we have in Excel

For example as a calculated column

Year=left([Month],4)

Month=right([Month],2)

Regards
Zubair

Please try my custom visuals

Zubair_Muhammad · ‎02-05-2019

@Anonymous

You can use same function like we have in Excel

For example as a calculated column

Year=left([Month],4)

Month=right([Month],2)

Regards
Zubair

Please try my custom visuals

Anonymous · ‎02-05-2019

Thank you 🙂 got it.

RE: Extract Year from YearMonth