Product: TIBCO Spotfire®
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
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. When setting a certain date using the calendar datepicker's upper limit on a column with data type DateTime, you will not see the data from the selected date. Only the time 00:00:00 will be included on the selected date. As designed, the selection will be made up to 00:00:00 on the selected day. 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.