Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
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:
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.
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Developer's Reference Published: 23 October 2003 |