清空筛选条件
清空筛选条件

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?

1 次查看（过去 30 天）
Bryan Wang
Bryan Wang 2017-8-27
评论： Bryan Wang 2017-8-27
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.

请先登录，再回答此问题。

采纳的回答

the cyclist
the cyclist 2017-8-27
datestr('2015-12-31','yyyymmdd')

更多回答（1 个）

Walter Roberson
Walter Roberson 2017-8-27
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.

类别

在 Help Center 和 File Exchange 中查找有关 Bloomberg Desktop 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by