Analyst: Using a calendar datepicker on a column of data type DateTime, the result will not include the date that is selected as the datepicker's upper limit.

Using a calendar datepicker on a column of data type DateTime, the result will not include the date that is selected as the datepicker's upper limit.

Details:

If you use the calendar datepicker on a range filter's upper limit to select a date (10-Jan, for example) from a column of type DateTime, the filtered result will not include the values on that day.

The filter's upper limit will be set to 10-Jan 00:00, and this will filter out all other DateTime selections on 10-Jan, such as 10-Jan 00:01 for example.

If you use a column of data type Date, selecting 10-Jan in the upper-limit calendar datepicker will include all the values from 10-Jan.

To have the whole day included when selecting an upper limit from a DateTime column, you need to select the day after the date of interest. For example, select 11-Jan instead of 10-Jan if you want to see all values from 10-Jan.