date computations in a table

I have a table LC that has a column of dates called "date". The date format is however 19850331. I want to extract the year and the month of this date. How can I do so?

Answer 1

[Andrei Bobrov]

LC.date = datetime(sprintfc('%d',LC.date),'InputFormat','yyyyMMdd');

LC.month_year = [month(LC.date),year(LC.date)]

Answer 2

[Peter Perkins]

Andrei provided the right answer if those data are text, e.g. '19850331' or "19850331". If they are numeric, use

datetime(LC.Date,'ConvertFrom','yyyymmdd')

[Andrei Bobrov]

Thank you Peter!