User Problem 

Visual SQL includes/excludes the date selected in the "Later than date" filter depending on if the column used in the filter is a DATETIME data type or a DATE data type. This is best explained by the following example: 

The "Created at" column is a DATETIME column. When filtering for a count of issues created by day for issues that were created at later than 2023-09-26, the results table includes issues that were created on 2023-09-26 (i.e. after the timestamp 2023-09-26 00:00:00): 

The "Due date" column is a DATE data type column. When filtering for a count of issues due by day for issues that have a Due date later than 2023-09-26, the results table excludes issues that were due on 2023-09-26: 

Suggested Solutions

When filtering on DATETIME data type columns, there should be an operator that allows for selecting date and time, rather than just date. This would allow for more accurate visual mode queries based on the data type of the column being used in the filter. 

Current Workarounds

Currently, users need to know ahead of time whether the column they are filtering on is a DATETIME or a DATE type column to know whether or not the date they select in the "Later than date" filter will be included or excluded in the results table.