Formating Dates and extracting Year

[niha]

Hello,

I have a date format like 201901, 201902, 201903....201801,201802....so on. I want to se the year of this year month. How to do that. Please suggest.

Year-month                    Year

201901                            2019

201902                            2019

201903                             2019

201801                             2018

201803                             2018

201807                            2018

I want to see the year(Green font) from Year month. Please suggest.

Regards,

Niha

[kaushiknsolanki · Accepted solution]

Hi,

Try this.

Load *,Left(Year-Month,4) as Year

From xyz;

Regards,

Kaushik Solanki

[niha]

Thanks. It worked!