Working with Dates

Date formats and timezones

While working with dates there are three possible formats you can get them in:

• Microsoft JSON Date Format
• ISO Format with timezone support
• ISO Format without timezone support

📘 All these formats can be also used in API v.1

Microsoft JSON Date Format (default one)

/api/v2/userstories?where=(id=3920)&select={PlannedEndDate}
/api/v2/userstories?where=(id=3920)&select={PlannedEndDate}&dateformat=ms

{
  "items": [
    {
      "plannedEndDate": "\/Date(1517525999000+0100)\/"
    }
  ]
}

ISO Format with timezone support

📘 Targetprocess server timezone is shown

/api/v2/userstories?where=(id=3920)&select={PlannedEndDate}&dateformat=iso

{
  "items": [
    {
      "plannedEndDate": "2018-02-01T23:59:59+01:00"
    }
  ]
}

📘 If you're using On-Demand account, you can check below your server timezone (with and without Daylight Saving Time). Private cloud customers can contact tp-support@apptio.com for such information

ISO Format without timezone support

/api/v2/userstories?where=(id=3920)&select={PlannedEndDate}&isodate=1

{
  "items": [
    {
      "plannedEndDate": "2018-02-01T23:59:59"
    }
  ]
}

Filter by Dates