# Strtotime() function is not working in filter query

**URL:** <https://kanboard.discourse.group/t/strtotime-function-is-not-working-in-filter-query/131>\
**Category:** Open Discussions\
**Created:** [January 22, 2019, 7:22am UTC](https://kanboard.discourse.group/t/strtotime-function-is-not-working-in-filter-query/131 "2019-01-22T07:22:35Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![rukunpuc](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/rukunpuc/32/50_2.png) [@rukunpuc](https://kanboard.discourse.group/u/rukunpuc)\
**Post date:** [January 22, 2019, 7:22am UTC](https://kanboard.discourse.group/t/strtotime-function-is-not-working-in-filter-query/131/1 "2019-01-22T07:22:35Z")

</div>

for example if i use the following queries they are not working in search panel:

1. due: +2 weeks
2. due: -2 days
3. due: next Friday

But if I use specific date then it is working:

due: \>= 2019-02-08

---

<div class="post-metadata">

**Author:** ![creecros](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/creecros/32/156_2.png) [@creecros](https://kanboard.discourse.group/u/creecros)\
**Post date:** [January 22, 2019, 3:23pm UTC](https://kanboard.discourse.group/t/strtotime-function-is-not-working-in-filter-query/131/2 "2019-01-22T15:23:11Z")

</div>

`due:"+2 Days"`  
`due:"-2 Days"`  
`due:"next Friday"`  
`due:Friday` or `due:"Friday"`

Must quote when Spaces, and can’t have a space between `due:` and `your condition`

---

<div class="post-metadata">

**Author:** ![rukunpuc](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/rukunpuc/32/50_2.png) [@rukunpuc](https://kanboard.discourse.group/u/rukunpuc)\
**Post date:** [January 22, 2019, 7:08pm UTC](https://kanboard.discourse.group/t/strtotime-function-is-not-working-in-filter-query/131/3 "2019-01-22T19:08:33Z")

</div>

Thanks for clear explanation.

---

<div class="post-metadata">

**Author:** ![kwet](https://avatars.discourse-cdn.com/v4/letter/k/898d66/32.png) [@kwet](https://kanboard.discourse.group/u/kwet)\
**Post date:** [March 1, 2021, 2:24pm UTC](https://kanboard.discourse.group/t/strtotime-function-is-not-working-in-filter-query/131/4 "2021-03-01T14:24:35Z")

</div>

Hello for display all task closed -10 days…  
If i write -10 days, i haven’t all task …-9 - 8 -7 etc…

---

<div class="post-metadata">

**Author:** ![creecros](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/creecros/32/156_2.png) [@creecros](https://kanboard.discourse.group/u/creecros)\
**Post date:** [March 2, 2021, 12:48am UTC](https://kanboard.discourse.group/t/strtotime-function-is-not-working-in-filter-query/131/5 "2021-03-02T00:48:07Z")

</div>

because “-10 days” is not a range.

---

<div class="post-metadata">

**Author:** ![kwet](https://avatars.discourse-cdn.com/v4/letter/k/898d66/32.png) [@kwet](https://kanboard.discourse.group/u/kwet)\
**Post date:** [March 2, 2021, 7:06am UTC](https://kanboard.discourse.group/t/strtotime-function-is-not-working-in-filter-query/131/6 "2021-03-02T07:06:06Z")

</div>

So why is it written in the online documentation :

 ![image](https://global.discourse-cdn.com/free1/uploads/kanboard1/original/1X/d63e939d0a51d355d4075279fb75b50dae80af0f.png)

---

<div class="post-metadata">

**Author:** ![creecros](https://yyz2.discourse-cdn.com/free1/user_avatar/kanboard.discourse.group/creecros/32/156_2.png) [@creecros](https://kanboard.discourse.group/u/creecros)\
**Post date:** [March 2, 2021, 12:24pm UTC](https://kanboard.discourse.group/t/strtotime-function-is-not-working-in-filter-query/131/7 "2021-03-02T12:24:12Z")

</div>

the documentation is correct. you’re missing the point though. it’s not a range. it represents exactly what it means, “-10 Days” is 10 days earlier than the day you ask the question, not every day in between.  
your questions says:

> [@kwet](#):
>
> If i write -10 days, i haven’t all task …-9 - 8 -7 etc…

and that is exactly correct, because -10 days represents the day that happened 10 days earlier than when you asked the question, not every day in between.