RS03325: DATE VALUE CHANGE WITH EXCEL IMPORT and EXPORT

Fixes are available

APAR status

Closed as program error.

Error description

The value for a  date column is entered as 12/31/9999, it will
show as 12/31/99 in RD, same format when published to DC BC.
When exported to Excel, it will show as 12/31/99. After
importing the same Excel back, it will shown as  'Dec 31 1999'
and edited as "12/31/1999 12:00:00 AM", both value and format
are changed unexpected

Local fix

```
NA
```

Problem summary

****************************************************************
* USERS AFFECTED:                                              *
* Decision Center users.                                       *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Importing and exporting retained formatting information.     *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

Problem conclusion

```
The code was fixed.
```

Temporary fix

Comments

APAR Information

APAR number
RS03325
Reported component name
WS DECISION CTR
Reported component ID
5725B6900
Reported release
892
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-02-25
Closed date
2019-04-24
Last modified date
2019-08-06

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

Fix information

Fixed component name
WS DECISION CTR
Fixed component ID
5725B6900

Applicable component levels

R892 PSY
UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSQP76","label":"IBM Operational Decision Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"892","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
24 November 2021

Tips

RS03325: DATE VALUE CHANGE WITH EXCEL IMPORT and EXPORT

Fixes are available

Subscribe

APAR status

Closed as program error.

Error description

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

APAR number

Reported component name

Reported component ID

Reported release

Status

PE

HIPER

Special Attention

Submitted date

Closed date

Last modified date

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Fix information

Fixed component name

Fixed component ID

Applicable component levels

R892 PSY

Document Information

Share your feedback

Need support?