The range from DateRange widget is always following the client timezone. There is the difference between the timezone of server and timezone of client. So we need to get the timezone difference between this two. This is how: we will create an hidden textbox and a javascript to fill the timezone of client. When user hit submit the daterange, the timezone difference will be submitted as well. At server-side, we will base on the time of server, timezone of server and timezone of client to determine the user-selected time range (in server timezone).

<form method="post">
    <?php
    DateRangePicker::create([...]);
    ?>

    <input type="hidden" id="clientTimeZoneOffset" name="clientTimeZoneOffset" />
    <script>
        $("#clientTimeZoneOffset") = new Date(). getTimezoneOffset();
    </script>
    <button type="submit">Submit</button>
</form>

At server-side, you can get the clientTimeZoneOffset from $_POST["clientTimeZoneOffset"], you use it to calculate correctly the selected time range from user.

Hope that helps.

Oh, do you use the Dashboard Framework? My above code is for normal report.

I am really sorry for the late reply. I answered you and guessed the issue was timezone difference between client browser and server but still not sure so I have consulted dev.team. They said that the Today selected date is actually your web server date, not client. So there is left is the different of timezone between your database server and web server. Is your database timezone different from your web server.

You have use select now() to know the time of database server. Let try to use PHP with the code

<?php

echo date("Y-m-d H:i:s");

Let see if there is difference between them.