Question

What is the format of the dtDue parameter when it comes to the XML API. On the UI, I can type in "tomorrow" and it gets converted to the proper date/time (obviously due to some javascript). On the XML API, I try "Feb 28, 2:00 PM" and it shows up as Feb 28, 2002, 5:00 PM. If I pass "2011-02-28T17:00:00-0700" it ends up as "Feb 28, 2011, 10 AM"

So what's the mystical format? I can't seem to find any docs on it.

Answer 1

The XML API is exptecting dates/times to be in ISO 8601 "universal combined" format (i.e., UTC dates/times): YYYY-MM-DDTHH:MM:SSZ, but will also accept SQL date format: YYYY-MM-DD HH:MM:SS.

To make sure you get what you want, use date+time in 2007-05-07T16:30:00Z format in UTC (i.e. don't forget to convert from your timezone to UTC before sending it to the FogBugz XML API)