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 [email protected] 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