My Oracle Support Banner

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 later
Information in this document applies to any platform.


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


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);


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




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.