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 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Bryan Wang
il 27 Ago 2017
Commentato: Bryan Wang
il 27 Ago 2017
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.
0 Commenti
Risposta accettata
Più risposte (1)
Walter Roberson
il 27 Ago 2017
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.
Vedere anche
Categorie
Scopri di più su Bloomberg Desktop in Help Center e File Exchange
Prodotti
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!