Maximo Open Forum

When creating a planning schedule in Excel, the date is in the wrong format, how to fix it?

Hi @Artyom Polyakov!

How do you export the records to excel? The process you use is what is complicating the visualization. You will have to analyze this process to be able to correct it.

Try to query it with a database client and export it to excel. Or use the "export to" process from IBM Maximo (from application ). Also, check if it is not possible to simply export the records. I see that the problem is with "Star Date" and "End Date" and then, you can try to add these 2 data as columns in list mode and export the records you need (you will not have problems that way).

Regards!

When creating a planning schedule in Excel, the date is in the wrong format, how to fix it?

The exported value is correct, but it is being displayed in Number or General format by Excel. You can just select the cells, change the format from General to Date as in the screenshot below.

When creating a planning schedule in Excel, the date is in the wrong format, how to fix it?