IJ03360: GANTT CHART - EXPORT TO EXCEL IS GETTING THE DATE COLUMNS ON DECIMAL NUMBER INSTEAD OF A DATE FORMAT.

APAR status

• Closed as program error.

Error description

• Once Scheduler 7.6.7 release migrate to the Tree Grid version
  13 we get the format of date columns to decimal instead of the
  date time format as expected.
  Pre Conditions
  - Have some Work Order with Duration, Schedule Start and
  Schedule End Dates
  - Have the Calendar and Shift valid (Not expired and Work
  Period applied)
  Steps to Reproduce
  1-) Go to the Graphical Scheduling application
  2-) Create a new record and setup name, calendar and Shift
  3-) At the Work Queries setup a condition to bring the Work
  Order that you created
  4-) Open the Gantt view tab
  5-) As it open at the Toolbar click at the Export to Excel
  format
  6-) Open the new file created
  PROBLEM: The Date columns at the Excel will get at Decimal
  number, if you apply the Date and Time format at Excel it will
  show as expected.
  EXPECT RESULT: It should get the Date and Time as you saw at
  Maximo Gantt Chart
  

Local fix

• Apply at Excel the Date and Time format to the Column
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of the Graphical Scheduling application.               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * EXPORT TO EXCEL IS GETTING THE DATE COLUMNS ONDECIMAL NUMBER *
  * INSTEAD OF A DATE FORMAT.                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• A code fix has been delivered.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• MAXIMO
  

Fix information

• Fixed component name

  MAXIMO SCHEDULE

• Fixed component ID

  5724R46SE

Applicable component levels

• R767 PSY

     UP