How to extract Month string from day_Month_Year time variable and create a new quarterly time index?

Hi, i have a time index in this following format: day_month_year, for example, Oct_01_2019, how will i extract the months and create a new variable of months or quarter?.

Thanks. .

Answer 1

[Shubham Gupta]

If I understand the question correctly, this should work :

Month_variable = datestr(datenum('Oct_01_2019'),'mm');

I hope it helps !

[mirewuti muhetaer]

Dear Gupta:

Thanks so much. Your help solved my whole day probelm. I can not appreciate more.

One more followup, if i want to extract both month and year, will i just add 'yyyy' right after 'mm'?.

Thanks.

[Shubham Gupta]

In that case, datevec() might be a better option.

Read more about it here.