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 replied to this.

  • 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

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

      Cheers.

          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?

              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

              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.

                  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..

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

                        Write a Reply...