Date Stamps and eScript
Last updated on MARCH 02, 2017
Applies to:Siebel Tools - Version 188.8.131.52 SIA  and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Professional)
Version: 184.108.40.206 
Database: Oracle 220.127.116.11
""Checked for Relevance on 22-JUL-2016""
Application Server OS: Microsoft Windows 2000 Server SP 4
Database Server OS: IBM AIX 5L 5.1
This document was previously published as Siebel SR 38-1959018141.
"Checked for relevance on 02-Feb-2015"
We have some functionality that is heavily dependent on timestamps. The process involves creating activity records, which we call CMDT requests. The process uses a customized bus comp based on the Action bus comp. When the user is ready for their request to be processed, they click on a 'Submit' button. There is eScript behind this button that does some validation and, if everything is OK, set the submitted data to the current date and time. When I look at the list applet in the gui that contains the Created field (vanilla) and the Submitted field (custom extension column), they are off by an hour. For example:
my PC time: 7:56:00 a.m
created: 12:47:56 p.m.
submitted: 11:49:09 a.m.
I also have a field on the applet that gets set to the current date and time when the user checks a corresponding checkbox. This field is set by a bus comp user property:
"AV Hier Move Complete?", "AV Hier Move Comp Date", "IIF ([AV Hier Move Complete?] = ""Y"", Timestamp (), """")"
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms