# Table Filtering adding a day? **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [April 10, 2025, 9:40pm UTC](https://forum.inductiveautomation.com/t/table-filtering-adding-a-day/104976 "2025-04-10T21:40:24Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![joe.bernicke](https://avatars.discourse-cdn.com/v4/letter/j/ea666f/32.png) [@joe.bernicke](https://forum.inductiveautomation.com/u/joe.bernicke)\ **Post date:** [April 10, 2025, 9:40pm UTC](https://forum.inductiveautomation.com/t/table-filtering-adding-a-day/104976/1 "2025-04-10T21:40:24Z")
Hello, So I have a filter and a date column. The filter seems to be adding a day to whatever I select in my filter. Am I missing something here? or is it something on the SQL end doing this? Any help is appreciated. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/f/bf4a9e859eb5ef4a9b94868c356eb11abee59e05.png) ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [April 10, 2025, 9:44pm UTC](https://forum.inductiveautomation.com/t/table-filtering-adding-a-day/104976/2 "2025-04-10T21:44:45Z")
It looks like you may not have set the `columns.x.field` property for each of your columns. You need to set this exactly to match the column names returned by the SQL query. Omitting this means certain features don't work on the column. If that doesn't fix it, post a sample of your table data and show your setup for the date column. ---
**Author:** ![joe.bernicke](https://avatars.discourse-cdn.com/v4/letter/j/ea666f/32.png) [@joe.bernicke](https://forum.inductiveautomation.com/u/joe.bernicke)\ **Post date:** [April 10, 2025, 9:51pm UTC](https://forum.inductiveautomation.com/t/table-filtering-adding-a-day/104976/3 "2025-04-10T21:51:22Z")
I do! ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/7/07ca2c1ef262c4b27f02572657a04e4b68e2d436.png) And here is my binding for my data. My column is named 'date'. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/3/c37c90cfec03815c54b159fd6e7bd8d6b38bf45d.png) ---
**Author:** ![code\_skin](https://avatars.discourse-cdn.com/v4/letter/c/43a26b/32.png) [@code\_skin](https://forum.inductiveautomation.com/u/code_skin)\ **Post date:** [April 10, 2025, 10:01pm UTC](https://forum.inductiveautomation.com/t/table-filtering-adding-a-day/104976/4 "2025-04-10T22:01:32Z")
What data types are you working with? ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [April 10, 2025, 10:04pm UTC](https://forum.inductiveautomation.com/t/table-filtering-adding-a-day/104976/5 "2025-04-10T22:04:13Z")
The binding preview looks like it's returning milliseconds. Is it a timezone problem? Is the filter not using the same timezone as the displayed data? ---
**Author:** ![joe.bernicke](https://avatars.discourse-cdn.com/v4/letter/j/ea666f/32.png) [@joe.bernicke](https://forum.inductiveautomation.com/u/joe.bernicke)\ **Post date:** [April 10, 2025, 10:16pm UTC](https://forum.inductiveautomation.com/t/table-filtering-adding-a-day/104976/6 "2025-04-10T22:16:35Z")
The date is a "date" datatype in postgresql database. "amount" is a Real. "category" and "description" are varchars. ---
**Author:** ![joe.bernicke](https://avatars.discourse-cdn.com/v4/letter/j/ea666f/32.png) [@joe.bernicke](https://forum.inductiveautomation.com/u/joe.bernicke)\ **Post date:** [April 10, 2025, 10:30pm UTC](https://forum.inductiveautomation.com/t/table-filtering-adding-a-day/104976/7 "2025-04-10T22:30:33Z")
This was it! Database was a different timezone from the gateway. Thanks!!!