Filter data by Date Range includes another Date

1

Hi,
I occured problem when I try to filter data by Date Range between dates;
For example I need do select data for March/01/2018
So I set timestamp filter to "Between March/01/2018 ~ March/01/2018"

But result includes some data for previous Day (February 28):

date_order
date_order556×646 119 KB

When I add Time to date to Date Range between dates result is correct:

date_time_order
date_time_order736×612 139 KB

Why that happens and is there way to solve that problem?

2

It’s a real pain but depending on your setup all the clocks down from the database even up to your browser in some cases has to be set right.

A good starting point for troubleshooting is :blue_book: this section in the Troubleshooting guide

1 Like
3

Jornh, thanks for your answer, that worked for me.
I figured it out by selecting the “Report Time Zone” setting in the General settings tab of the Admin Panel.

1 Like