Date Format

tjlloyd

We're looking to upgrade to 1.12.2 (a5d898b), but we also want to upgrade the version of windows the installation is sitting on, so I decided to completely spin up a new machine/install. Once I had MySQL, 5.5.62, PHP 7.3.7 installed and all of the windows updates run, I backed up our existing database and restored it on the new instance and proceeded with installing osTicket 1.12.2 Everything went smoothly and appears to have moved over appropriately. However, the date of tickets is being displayed as "09/20/19 15:54:02" where on our previous production install, v1.10 (901e5ea), date/time is displayed as "09/20/19 3:54 PM". All of the Date and Time Options match from 1.10 to 1.12, I tried using "--Advanced--" but as soon as I put in the "a" character (as prescribed the ICU Date Formatting table referenced in the help pop up) the entire field does not render. I've also checked the Locale options within my php.ini and made adjustments there with no effect.

I know this is purely cosmetic, but my users are going to lose their minds if they have to try to tell time in 24 hour format.

Any help would be greatly appreciated.

ntozier

Try going to Admin panel -> Settings -> System and changing Date and Time Format to Locale Defaults.

tjlloyd

@ntozier that's the default setting and does not produce the desired result.

KevinTheJedi

@tjlloyd

Use PHP date/time format options:
https://www.php.net/manual/en/function.date.php

Also you might need this:
https://github.com/osTicket/osTicket/pull/5044

Cheers.

tjlloyd

KevinTheJedi Thank you, I'll give those a go.

tjlloyd

KevinTheJedi No dice with either suggestion. Using PHP date/time format options I get the same behavior. "MM/dd/y hh:mm a" renders NOTHING with or without the new scp.js.

If I change the format to: "MM/dd/y hh:mm A" it renders the date and time correctly, but "A" is static, it doesn't act like a variable. (per the PHP Date/Time format it should produce uppercase "AM" or "PM") In fact, per the PHP date format instructions, "M" should produce "Sep" but when I use "M" I'm getting exactly "M", it's not being replaced with any value. With ICU I should get "9" and with php date format, I should see "Sep". But I just get "M"

"MM" in the date format options seems to work correctly according to ICU

But sticking with ICU and adding "a" brings us back to nada:

KevinTheJedi

@tjlloyd

Here is what works for me:

If this doesn’t work for you then I would var_dump around to see where it’s failing.

Cheers.