Date datatype for tasks entity does not give expected output for boundary conditions

English Forum Developers & API
1

Date datatype for tasks entity does not give expected output for boundary conditions. Scenario : When hitting the API with “due_on.after” as “2019-09-14” and “due_on.before” as “2019-09-14” then we are getting data having due_date as “2019-09-14” and “2019-09-15” but its expected to give the data for “2019-09-14” only. If anyone can guide me on this, why is the API behaving like this and is this as expected behavior.

Request:

curl --location ‘https://app.asana.com/api/1.0/workspaces/1202358725229119/tasks/search?due_on.after=2019-09-14&due_on.before=2019-09-14&opt_fields=gid%2Cresource_type%2Chtml_notes%2Cdue_on’
–header ‘Authorization: Bearer <PAT_TOKEN>’

Response:

{
“data”: [
{
“gid”: “1204354248384497”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204477445600107”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204477559951666”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204477446140207”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204477586394523”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204477669016330”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204477530083508”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204477584107183”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204477437920812”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204477584138677”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184515855007”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184515854943”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184004441581”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184515854879”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184003502458”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184380797564”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184001396889”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184003926641”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184003926577”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184380337659”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184003367714”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184091099041”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184088784148”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184378320125”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184077994849”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153737454930”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153478428635”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153737451664”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153415372757”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153419325366”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153478427451”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153733863761”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153735967771”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153590157894”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153419325430”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153416472746”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153475656977”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153734597445”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153473783110”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153734598699”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153731880459”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153734597541”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153408636497”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153416472682”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153730894432”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153404468617”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153472303494”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153413181211”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153472303430”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153413181115”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153595129066”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153413181437”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153584176482”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153731374764”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153592307159”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153324285941”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153592307091”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153322525649”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153467995790”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153588945763”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153463998497”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153326356171”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153403042685”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153408963565”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153407483409”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153465486483”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153592277643”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153592277707”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153592123194”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153467980783”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153467980913”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153403504873”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153408944199”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153591023492”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153407316341”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204354302564856”,
“due_on”: “2019-09-14”,
“html_notes”: “Mittens really likes the stuff from Humboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204756393900184”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204741126820000”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740625793854”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740624320216”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740684846932”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740625480584”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740764069926”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740766944773”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740758390571”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740766967336”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740762883294”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740763576140”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740750079320”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740609883641”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740612792595”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740753087200”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740612792731”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740749549819”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740751747120”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740669795891”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740670550202”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740666539650”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740517225703”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740516044402”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
}
]
}

2

@Manoj_Bhosale - is there a reason you aren’t using due_on to narrow to a specific date (instead of conditioning before and after)? That said, I don’t have this issue when I set due_on.before and due_on.after to the same date.

Do any of those tasks have times on their due date?

3

I am trying to retrieve data for a specific range within the “due_on” field. This range could span as little as a single day or as large as any extensive date range.
Here when I check for data with due_on after 2019-09-13 and before 2019-09-14, I am getting data with due_on as 2019-09-15 as well. Due_on is a date field and an trying to check for date fields only for datetime fields such as “created_at”, “modified_at” the behavior is as expected only.

Request:

curl --location ‘https://app.asana.com/api/1.0/workspaces/1202358725229119/tasks/search?due_on.after=2019-09-13&due_on.before=2019-09-14&opt_fields=resource_type%2Chtml_notes%2Cdue_on’
–header ‘Accept: application/json’
–header ‘Authorization: Bearer ’

Response:

{
“data”: [
{
“gid”: “1204354248384497”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204477445600107”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204477446140207”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204477559951666”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204477586394523”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204477669016330”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204477437920812”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204477530083508”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204477584107183”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204477584138677”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184515855007”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184515854943”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184004441581”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184515854879”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184003502458”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184380797564”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184001396889”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184003926641”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184003926577”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184380337659”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184003367714”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184091099041”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184088784148”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184378320125”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205184077994849”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153737454930”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153478428635”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153737451664”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153415372757”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153419325366”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153478427451”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153733863761”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153735967771”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153590157894”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153419325430”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153416472746”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153475656977”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153734597445”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153473783110”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153734598699”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153731880459”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153734597541”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153408636497”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153416472682”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153730894432”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153404468617”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153472303494”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153413181211”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153472303430”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153413181115”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153595129066”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153413181437”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153584176482”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153731374764”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153592307159”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153324285941”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153592307091”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153322525649”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153467995790”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153588945763”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153463998497”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153326356171”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153403042685”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153408963565”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153407483409”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153465486483”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153592277643”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153592277707”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153592123194”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153467980783”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153467980913”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153403504873”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153408944199”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153591023492”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1205153407316341”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204354302564856”,
“due_on”: “2019-09-14”,
“html_notes”: “Mittens really likes the stuff from Humboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204756393900184”,
“due_on”: “2019-09-14”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204741126820000”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740625793854”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740624320216”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740684846932”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740625480584”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740764069926”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740766944773”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740758390571”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740766967336”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740762883294”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740763576140”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740750079320”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740609883641”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740612792595”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740753087200”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740612792731”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740749549819”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740751747120”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740669795891”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740670550202”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740666539650”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740517225703”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
},
{
“gid”: “1204740516044402”,
“due_on”: “2019-09-15”,
“html_notes”: “MittensreallylikesthestufffromHumboldt.”,
“resource_type”: “task”
}
]
}

4

My guess is it has something to do with timezone.

You can try with “due_at” filter instead of “due_on” (with complete time)

Also, ask for due_at field in opt_fields, that can help you understand what is happening.

“due_at.before=2019-09-15T00:00:00Z” (iso8601 UTC string format)

1 Like
5

I also don’t get the behavior you’re seeing; I’m not getting tasks outside the date range when I set due_on.before and due_on.after like you did.

I agree with the others here: when you’re working with the due date of a task, it’s best to look at and consider both due_on and due_at to get a full picture of a task’s due date. On some tasks, no specific time was entered, so due_at will be null. On other tasks, a time was entered and you’ll see it in due_at.

In particular, it would be interesting to see what the due_at value is for those tasks in your result that are due_on 2019-09-15.

1 Like