how do i convert my matlab date format, such as '2015-12-31' to a date format 20151231, which is required as the Bloomberg End_Dt?

I am trying to pull data from Bloomberg, using the following.

d = getdata(c,'SPX Index','INDX_MEMBERS','End_DT', RebalanceDate)

However, it appears that Bloomberg requires the "RebalanceDate' field to be in the format of 'yyyymmdd'. My RebalanceDate is in Matlab format : 2015-12-31, for example.

Does anyone know how I can convert 2015-12-31 to 20151231?

Many thanks for your help.

Answer 1

[the cyclist]

datestr('2015-12-31','yyyymmdd')

[Bryan Wang]

thank you so very much Cyclist. This works well.

Answer 2

[Walter Roberson]

If you have the date in the form of a string, then just delete the '-' characters.

If you have it in the form of a datenum, then like the cyclist shows, datestr() it with appropriate format.

If you have it in the form of a datetime, set its Format property to 'yyyyMMdd' and then char() the object to get the string.

[Bryan Wang]

thank you very much for the very prompt help. I have spent several hours searching online and trying different ways.

This really helps. Many thanks.