When a filter that uses a date range is applied, 12 a.m. on the "to" date (end date for the date range) is used as the cutoff for results. This means that only data from the time period prior to the start of this "to" date will be displayed.

For example, if running a "Last Order Date" query using the date range 02/08/11 to 02/09/11, only customers whose last order with your store was placed on 02/08/11 would be included in the returned results. Customers whose last order with your store was placed on 02/09/11 would not be displayed in the results. In order to display customers whose last orders were placed on 02/08/11 and 2/09/11, the date range of “From 2/08/11 to 2/10/11” needs to be used.