Filter: Create Date does not result to the correct date.

cortkny2024

I created a filter in osTicket > Admin Panel with the following critera:

TicketStatus / State includes Open, Closed
AND Department includes IT Dept.
AND Create Date is 12/7/24 3:00

However, based on the results, the create date shows the previous day instead of Dec 7,2024

![
](https://)

My Timezone is set to Taipei on both the server and client machines. I have deployed the osTicket 1.18.1 in Windows Server 2019.

Looking forward to hear from your end
Thank you in advanced!
Knychtell

KevinTheJedi

cortkny2024

What is your server time zone, MySQL time zone, PHP time zone, help desk system time zone, and profile time zone?

Cheers.

cortkny2024

KevinTheJedi All the timezones are in Taipei. I just noticed in the search criteria it is set to AMERICA/CHICAGO

![
](https://)
Where do I change this to reflect the correct date? also, would this explain why the Dashboard also shows incorrect dates?

KevinTheJedi

cortkny2024

Post a screenshot of Admin Panel > Dashboard > Information as well Admin Panel > Settings > System.

Cheers.

cortkny2024

KevinTheJedi ![
](https://)

![
](https://)

cortkny2024

Sorry for multiple posts:

MySQL Timezone is using SYSTEM

SELECT @@global.time_zone;
If I run the query- it shows the correct date and time.
SELECT NOW();

So its only when I set the Search Criteria for the Dates shows CST Timezone.

I saw a youtube video for osticket advanced searches (publised 4 years ago) shows there was a settings > option to set the timezone which I am no longer seeing in v1.18.1.
Looking forward to hear from your end
Thank you in advanced!
Knychtell

KevinTheJedi

cortkny2024

Check the time zone in your Profile (Profile > Preferences > Time Zone).

Cheers.

cortkny2024

KevinTheJedi the profile preference is also set to taipei

KevinTheJedi

cortkny2024

What is your PHP INI date.timezone?

Cheers.

cortkny2024

KevinTheJedi ASIA/Taipie as well for Profile preferences and PHP.INI

![
](https://)

KevinTheJedi

cortkny2024

Go to your js/jstz.min.js file, search for "Perth", change the line from "Australia/Perth":new Date(2008,10,1,1,0,0,0) to "Australia/Perth":new Date(2008,10,1,1,0,0,0),"Asia/Taipei":new Date(2008,10,1,1,0,0,0), then search for "shanghai", change the line from Asia/Shanghai":["Asia/Krasnoyarsk","Australia/Perth"] to Asia/Shanghai":["Asia/Krasnoyarsk","Australia/Perth","Asia/Taipei"], save the changes, restart IIS, hard reload your browser, and retest.

Cheers.

cortkny2024

KevinTheJedi This worked! thank you very much.

One more thing about the date/time picker- if I select any date, after I save it it goes Forward 1 day.
![
](https://)

After saving..

KevinTheJedi

cortkny2024

Well your screenshot is still showing CST so it doesn’t appear to be working.

Cheers.

cortkny2024

True. What would you suggest that I do to make sure that it flreflects the ASIA/TAIPEI?

KevinTheJedi

cortkny2024

Idk I’ll have to test around with it and see.

Cheers.