# Filter on tables seems broken

**URL:** <https://forums.losant.com/t/filter-on-tables-seems-broken/5291>\
**Category:** Bug Report\
**Tags:** data-table\
**Created:** [October 12, 2023, 8:37am UTC](https://forums.losant.com/t/filter-on-tables-seems-broken/5291 "2023-10-12T08:37:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Paolo\_Proxy](https://avatars.discourse-cdn.com/v4/letter/p/b5ac83/32.png) [@Paolo\_Proxy](https://forums.losant.com/u/Paolo_Proxy)\
**Post date:** [October 12, 2023, 8:37am UTC](https://forums.losant.com/t/filter-on-tables-seems-broken/5291/1 "2023-10-12T08:37:29Z")

</div>

Hi there,  
I think there is a problem here

![image](https://us1.discourse-cdn.com/flex015/uploads/getstructure/original/2X/8/80cbbcd20a6e81bd4973c144bb50dd880fc34b8f.png)

but then look at the Node table, same query it returns me zero entries

 ![image](https://us1.discourse-cdn.com/flex015/uploads/getstructure/original/2X/b/b9ef537b5dee2681216332150e71c0a991474373.png)

---

<div class="post-metadata">

**Author:** ![Dylan\_Schuster](https://sea1.discourse-cdn.com/flex015/user_avatar/forums.losant.com/dylan_schuster/32/2850_2.png) [@Dylan\_Schuster](https://forums.losant.com/u/Dylan_Schuster)\
**Post date:** [October 12, 2023, 1:56pm UTC](https://forums.losant.com/t/filter-on-tables-seems-broken/5291/2 "2023-10-12T13:56:06Z")

</div>

I think the problem lies in the string you entered within the query for the “createdAt” field. In the data table query within the application view, we provide a datepicker there that displays the date and time in the user’s locale format, but the underlying value is actually a Unix timestamp (milliseconds since Epoch).

In the workflow node, we have a regular text input there because users may enter a [string template](https://docs.losant.com/workflows/accessing-payload-data/#string-templates) in that field or a date. When I enter “12 Oct 2023” I get results, but when I enter “12 Oct 2023 08:00:00”, nothing is returned. So whatever we are using to parse dates in the workflow runner may not be able to make sense of that input.

I would suggest using a timestamp there instead; the easiest way to get one is to use the [Date/Time Node](https://docs.losant.com/workflows/logic/date-time/) to parse a date you enter, convert it to the correct format, and then store it on the payload, which you can then reference in the Table: Get Rows Node query.

---

<div class="post-metadata">

**Author:** ![Paolo\_Proxy](https://avatars.discourse-cdn.com/v4/letter/p/b5ac83/32.png) [@Paolo\_Proxy](https://forums.losant.com/u/Paolo_Proxy)\
**Post date:** [October 16, 2023, 2:57pm UTC](https://forums.losant.com/t/filter-on-tables-seems-broken/5291/3 "2023-10-16T14:57:03Z")

</div>

I see what you mean I will use the variable approach then.