We have had a lot of developers report a bug about the format of date returned from the reports API response.
Even though the reports API specification mentions that all dates are in YYYY-MM-DD format, this does not hold good for cases where company settings are modified to use a different formatting option for date values. Instead of YYYY-MM-DD date values are generated using the company’s date formatting options (as set in company settings).
In the release slated for the April/May timeframe, we will be fixing the date values presented in the reports API responses. To conform to the API specification & ease the parsing of date values all date values will be in YYYY-MM-DD format after the fix release. Developers can be assured that no matter what date format is set in the company settings, the response date format will be YYYY-MM-DD.
Please note this change only applies to the report API responses.
What does this mean for you?
Our recommendation to you is that if you are using the reports API, please make sure that you can parse the date format (YYYY-MM-DD) in your code. After the bug fix release,eventually you can get rid of the extra code you might have written to accommodate the different date formats from the report API response.
The Reports API specification can be found here: https://developer.intuit.com/docs/0100_Accounting/0400_References/reports