Date to Milliseconds Conversion is Giving Negative Value When Date Field Value Exceeds to 1/19/2038
(Doc ID 2973729.1)
Last updated on OCTOBER 29, 2023
Applies to:
Siebel CRM - Version 20.8 and laterInformation in this document applies to any platform.
Symptoms
Converting a date to milliseconds format using the ToNumber() function is giving a negative value when the date exceeds 1/19/2038 on any Date Field
STEPS
-------
The issue can be reproduced at will with the following steps:
1)Login to Siebel Tools
2)Go to Business Component and Select 'Action' Business Component
3)Right Click on Business Component and click on Edit Server Script
4)Write the Code as below for 'Planned' field i.e Planned Field is the date field
var EndDate = this.GetFieldValue("Planned");
var oEndDate = new Date(EndDate);
var oEndDate_d = oEndDate.toSystem();
var oEndDate_dToNum = ToNumber(oEndDate_d);
TheApplication().RaiseErrorText(oEndDate_dToNum);
5)Deliver the changes
6)Login to Siebel Application
7)Go to Activities Screen
8)Update 'Planned Start' date field to 1/19/2038 from Activity List Applet
9)Save the record and observe the converted Milli seconds value is displaying in negative value from UI
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |