Starting the April 17th 2019, we will be changing the date format to yyyy-mm-dd which you will see for all files you download such as transactions, historical returns, etc…
If you are running scripts, please plan to adjust to this new format.
Any chance you could post another message here with 2 example files attached before vs after?
(to be able to test and make sure my code works directly on April 17th)
Will this affect inbound dates (i.e., when specifying a date via “asof” in a script)? Will this also affect the display of dates in headers or just in the context of tables?
Thanks for letting us know in advance.
Will existing Exposure List dates all be automatically changed to the new format as well, or do we have to change the dates manually?
This will affect file downloads only. Attached is a random transactions sample file for both before and after the date format change. The format change will not be implemented for any notes in the files at the moment.
Most likely we will implement the change at the end of business day April 17th. I will keep you updated
Thanks
FYI, if I am not mistaken, the sample for “before change” does not exactly reflect an actual transaction file we can download (I just tried):
Date from the attached sample file is e.g.4/9/2019 (no leading zeros and has 20xx)
Date from currently downloadable transaction files = e.g. 04/09/19 (has leading zeros and no 20xx)
As long as it sorts properly in Excel—as the download seemed to do when pasted into excel—then good for me.
I am not a programmer (but would like to be and I am slowly learning). You would think this format should sort even if Excel does not recognize it as a date (Excel did not seem to recognize it as a date). It did sort properly. This is stuff you already know about and I know you have already considered it.
Here is a list of all affected endpoints:
[][font=courier new]/app/account/trans.csv[/font][][font=courier new]/app/rollingTest/resultsTableDl/[/font][][font=courier new]/app/watchlist/items.csv?v=basic[/font][][font=courier new]/p123/DownloadPortPeriodPerformance[/font][][font=courier new]/p123/DownloadPortTrans[/font][][font=courier new]/p123/DownloadRankings[/font] (header line)[*][font=courier new]/transact_real.jsp?download=[/font]Note that [font=courier new]/p123/DownloadStudyResults[/font] will not be affected.