# List filter not working on dates with the "is" selector

**URL:** <https://community.forestadmin.com/t/list-filter-not-working-on-dates-with-the-is-selector/6061>\
**Category:** Help me!\
**Tags:** dashboard\
**Created:** [March 8, 2023, 6:27am UTC](https://community.forestadmin.com/t/list-filter-not-working-on-dates-with-the-is-selector/6061 "2023-03-08T06:27:17Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Aarbel](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/aarbel/32/3517_2.png) [@Aarbel](https://community.forestadmin.com/u/Aarbel)\
**Post date:** [March 8, 2023, 6:27am UTC](https://community.forestadmin.com/t/list-filter-not-working-on-dates-with-the-is-selector/6061/1 "2023-03-08T06:27:17Z")

</div>

Hi Forest Admin teams,

I have an issue filtering rows by dates with the “is” selector. It seems that your filter applies on miliseconds and not seconds like displayed, causing not matching filter.  
So how to filter rows to find a row at a precise date in seconds ?

Thanks for your help

Screenshots bellow:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/forest/original/2X/c/c54b6b05eb86e0038555d4b9be990741f414a941.png)  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/forest/original/2X/e/e1d9fb7e0880869f5bb84d1375e091ced3f7f6ed.png)  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/forest/original/2X/2/22979c96c94c4e2dc3e8771a33b184210b84b3b5.png)

---

<div class="post-metadata">

**Author:** ![morganperre](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/morganperre/32/1296_2.png) [@morganperre](https://community.forestadmin.com/u/morganperre)\
**Post date:** [March 8, 2023, 10:15am UTC](https://community.forestadmin.com/t/list-filter-not-working-on-dates-with-the-is-selector/6061/2 "2023-03-08T10:15:36Z")

</div>

Hi @Aarbel! Welcome back. 👋

Can you fulfill this part of the template so we can give you the best answer?

> - Project name: …
> - Team name: …
> - Environment name: …
> - Agent (forest package) name & version: …
> - Database type: …

> [@Aarbel](#):
>
> I have an issue filtering rows by dates with the “is” selector. It seems that your filter applies on miliseconds and not seconds like displayed, causing not matching filter.

Indeed, your screenshots are relevant. Thanks for sharing them. 🙏  
Let me know what **agent** (forest package) you’re using so we can help you.

kind regards,  
Morgan

---

<div class="post-metadata">

**Author:** ![Aarbel](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/aarbel/32/3517_2.png) [@Aarbel](https://community.forestadmin.com/u/Aarbel)\
**Post date:** [September 27, 2023, 1:35pm UTC](https://community.forestadmin.com/t/list-filter-not-working-on-dates-with-the-is-selector/6061/3 "2023-09-27T13:35:08Z")

</div>

Sorry i missed your feedback, here are the details:

- Project name: “Clovis V2 (Prod / Staging / Dev)”
- Team name: no team, just “ADMIN” user
- Environment name: “Production”
- Agent (forest package) name & version: “forest-express-sequelize”: “8.5.14”,
- Database type: PostgreSQL

Thanks a lot for your help !

---

<div class="post-metadata">

**Author:** ![morganperre](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/morganperre/32/1296_2.png) [@morganperre](https://community.forestadmin.com/u/morganperre)\
**Post date:** [September 28, 2023, 1:36pm UTC](https://community.forestadmin.com/t/list-filter-not-working-on-dates-with-the-is-selector/6061/4 "2023-09-28T13:36:13Z")

</div>

Hello @Aarbel,

You are right, I just reproduced the same behavior, but I think this is the expected behavior. 🤔

> **Payload sent to the agent (\`forest-express-sequelize\` in your case)**
>
> ```javascript
> {"field":"createdAt","operator":"equal","value":"2023-09-19T22:00:01.000Z"}
> 
> ```

I will share the feedback with our team and come back to you with more information.

In the meantime, you can use the following workaround to fulfill the same behavior.

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/forest/original/2X/e/eb52c7fc7964d3d6a1b9fff7bf3c1599e8e2ad08.png)

Kind regards,  
Morgan