cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Chanty4u Member
Member

RE: Extract Year from YearMonth

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: RE: Extract Year from YearMonth

@Chanty4u

 

You can use same function like we have in Excel

 

For example as a calculated column

 

Year=left([Month],4)
Month=right([Month],2)
2 REPLIES 2
Super User
Super User

Re: RE: Extract Year from YearMonth

@Chanty4u

 

You can use same function like we have in Excel

 

For example as a calculated column

 

Year=left([Month],4)
Month=right([Month],2)
Chanty4u Member
Member

Re: RE: Extract Year from YearMonth

Thank you Smiley Happy got it.