# REST API "Tasks" sqlfilters Statement

**URL:** <https://www.dolibarr.org/forum/t/rest-api-tasks-sqlfilters-statement/24489>\
**Category:** Using my Dolibarr\
**Tags:** API\
**Created:** [October 30, 2023, 3:31am UTC](https://www.dolibarr.org/forum/t/rest-api-tasks-sqlfilters-statement/24489 "2023-10-30T03:31:09Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![gsfr](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/g/e36b37/32.png) [@gsfr](https://www.dolibarr.org/forum/u/gsfr)\
**Post date:** [October 30, 2023, 3:31am UTC](https://www.dolibarr.org/forum/t/rest-api-tasks-sqlfilters-statement/24489/1 "2023-10-30T03:31:09Z")

</div>

What is the correct “sqlfilters” statement to use within the Rest API to get tasks with a “date\_end” that is later than 01/01/2020 ?

---

<div class="post-metadata">

**Author:** ![jonbendtsen](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/977dab/32.png) [@jonbendtsen](https://www.dolibarr.org/forum/u/jonbendtsen)\
**Post date:** [October 31, 2023, 9:29pm UTC](https://www.dolibarr.org/forum/t/rest-api-tasks-sqlfilters-statement/24489/2 "2023-10-31T21:29:36Z")

</div>

I’m not using that, but you probably need to have date\_end be larger than that date in seconds since January 1st 1970.

---

<div class="post-metadata">

**Author:** ![jonbendtsen](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/977dab/32.png) [@jonbendtsen](https://www.dolibarr.org/forum/u/jonbendtsen)\
**Post date:** [November 15, 2023, 11:04pm UTC](https://www.dolibarr.org/forum/t/rest-api-tasks-sqlfilters-statement/24489/3 "2023-11-15T23:04:05Z")

</div>

probably something like this would work (t.date\_creation:\>:1699463468)

with the correct number other than 1699463468

---

<div class="post-metadata">

**Author:** ![gsfr](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/g/e36b37/32.png) [@gsfr](https://www.dolibarr.org/forum/u/gsfr)\
**Post date:** [November 23, 2023, 3:42am UTC](https://www.dolibarr.org/forum/t/rest-api-tasks-sqlfilters-statement/24489/4 "2023-11-23T03:42:41Z")

</div>

Thank you, much appreciated.

---

<div class="post-metadata">

**Author:** ![jonbendtsen](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/977dab/32.png) [@jonbendtsen](https://www.dolibarr.org/forum/u/jonbendtsen)\
**Post date:** [February 4, 2024, 12:21pm UTC](https://www.dolibarr.org/forum/t/rest-api-tasks-sqlfilters-statement/24489/5 "2024-02-04T12:21:57Z")

</div>

did you find a solution?

---

<div class="post-metadata">

**Author:** ![tindoshox](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/t/7cd45c/32.png) [@tindoshox](https://www.dolibarr.org/forum/u/tindoshox)\
**Post date:** [February 5, 2024, 10:52pm UTC](https://www.dolibarr.org/forum/t/rest-api-tasks-sqlfilters-statement/24489/6 "2024-02-05T22:52:08Z")

</div>

I’m not sure what you mean by date\_end but this works for me to show invoices with a due date after 01/01/2020

**(t.date\_lim\_reglement:\>:‘2020-01-01’)**

For some fields like datec (datecreated) and datem (date modified) it appears to umiplemented.

---

<div class="post-metadata">

**Author:** ![jonbendtsen](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/977dab/32.png) [@jonbendtsen](https://www.dolibarr.org/forum/u/jonbendtsen)\
**Post date:** [February 6, 2024, 5:48pm UTC](https://www.dolibarr.org/forum/t/rest-api-tasks-sqlfilters-statement/24489/7 "2024-02-06T17:48:16Z")

</div>

okay thanks. That field does not seem to exist for proposals or orders, but other date fields do. Unfortunately I still get proposals and orders from before (t.datep:\>:‘2024-01-01’) and I would expect \> to mean that only those fields with a date bigger than that date.

If i turn it around (t.datep:\<:‘2024-01-01’) I get no proposals found ?? and there should be ☹