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.
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.
What data types are you working with?
1 Like
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?
2 Likes
The date is a "date" datatype in postgresql database. "amount" is a Real. "category" and "description" are varchars.
This was it! Database was a different timezone from the gateway. Thanks!!!