Is it May 6 or June 5? Customize How the Date is Displayed in IBM Maximo

Is it May 6 or June 5? Customize How the Date is Displayed in IBM Maximo

I’m sure you all remember when “The Dress” broke the internet in 2016. Was it white and gold or black and blue? And more recently, we’re seeing something similar with the Laurel/Yanny debate. Who’s right? It all depends on how you’re “built”.

I was on a support call recently, where I ran into a similar situation. During a screenshare, both the client and I were looking at the same screen, but the conversation led us to scratch our heads, wondering what on Earth the other person thought they were seeing.

I’ll show you what we were looking at that was causing all the commotion.

05/06/18 3:15PM

Seems pretty harmless, right? Well, not if one of you is in the US and the other is in Canada – which is exactly the pickle that our client and I found ourselves in.

She saw the date as the 5th of June, 2018, while I insisted it was the 6th of May. Now, of course, I was right, but that’s beside the point.

How do you read the date in your SQL tool, Maximo, AKWIRE and more?

Just for fun, we searched the database for that record. And, as you probably know, the format of the date in the database is different than what you see in Maximo.

In her SQL tool, the date looked like this: 2018-06-05 15:15:06.000, a completely different format than what we were seeing in Maximo. But since this customer is implemented in a MSSQL database, we ran “dbcc useroptions” and saw that the database date format was Month/Day/Year.  

The point is: there are several different ways to read a displayed date, depending on where you grew up, and it’s been ingrained in you since you were small. But how you prefer to see the date may not be how your IBM Maximo CMMS is configured to display the date.

Configuring the date in IBM Maximo CMMS

If you ever ran into this issue, you may have asked yourself, “Why is it like this? Is there a better way to handle this situation?” Or maybe you’ve chosen to live with it. Well, if you want to change the way the date is displayed, there’s good news: you can. And it’s pretty easy.

Maximo displays the date format based on either the configured Maximo System Properties, the Maximo users’ Locale setting, or the client machine JVM Default Locale. The previously listed order is the sequence that Maximo will look at the “parameters” to set the way the date is displayed. If the first one is null, it will go to the next available entry to define the format to display. So, there are multiple options to configure this:

  • You can set the setting.DISPLAYDATE
  • Please consider if you’re doing this, it will be a global setting affecting all Maximo users.
change-display-date-ibm-maximo-cmms

You can set the Locale on your Maximo default information.

  • In this case, this change only applies to you.
ibm-maximo-ERP-display-date


  • Or, you can set the Language Preferences in IE to your preferred language, which will drive the date format based on your machine configuration.
  • Same as above, this change only affects what you see, not others.

enterprise-asset-management-display-date-maximo

So, whether you live in the Great White North, the good ole USA, the Outback, or anywhere in between, you should be able to display the date in IBM Maximo CMMS in a way that makes sense for you.

Similar Posts

Offices
Company Headquarters
4601 Six Forks Rd Ste 220
Raleigh, NC 27609
Phone: +1 (888) 317-2397
Raleigh, NC
4601 Six Forks Rd Ste 220
Raleigh, NC 27609
Phone: +1 (888) 317-2397
San Antonio, TX
18880 Stone Oak Pkwy
San Antonio, TX 78258
Phone: (210)-201-8189
Gateshead, UK
Baltic Place, S Shore Rd, Gateshead
NE8 3AE, United Kingdom
Phone: +44 191 201 7777
Leeds, UK
1 York Pl, Leeds
LS1 2DR, United Kingdom
Phone: +44 113 827 0080
Melbourne, AU
16 Kirk St, Moe VIC
3825, Australia
Phone: +61 3 5132 2600
Brisbane, AU
8A/36 Agnes St, Fortitude Valley
QLD 4006, Australia
Phone: +61 7 3102 3877
Hamilton, CA
50 Dundas St E, Dundas, ON
L9H 7K6, Canada
Phone: +1 905-544-4144
Dordrecht, NL
Burgemeester de Raadtsingel 67, 3311 JG
Dordrecht, Netherlands
Phone: +31 78 614 6288
Kerkrade, NL
Eurode-Park 1,Kerkrade, Limburg 6461
KB, Netherlands
Phone: +31 78 614 6288
São Paulo, BR
R.Olimpíadas, 205, 4. Andar
São Paulo, SP, CEP 04551-000
Phone: +55 553 728-9372
Pretoria, SA
1 Pegasus Building 210 Amarand Ave
Waterkloof Glen, Pretoria, 0181
South Africa
Phone: +27 12 003 2916