Siebel Developer's Reference > Operators, Expressions, and Conditions > Functions in Calculation Expressions >

Using Datetime Fields in Calculations

It is possible to perform calculations with datetime fields in calculated fields. When a number is entered in a datetime field, days are represented by integers and hours, and minutes and seconds are represented by fractions.

For example, to add one minute to the current date and time, use the following expression, which is derived from the fact that one day has 1440 minutes:

Timestamp() + 1/1440

In this example the product delivery interval, measured in seconds, is added to the current date and time:

Timestamp() + [Product Delivery Interval]/86400

NOTE:  The Type property of the calculated field must be of type DTYPE_DATETIME.