1. Developer’s Reference
  2. Configuring Siebel CRM to Do Calculations with the Timestamp Function

Configuring Siebel CRM to Do Calculations with the Timestamp Function

Use the Timestamp function for fields of type DTYPE_DATETIME and DTYPE_UTCDATETIME. If you configure Siebel CRM to do a calculation that involves seconds, then it is recommended that you use at least five significant figures for accuracy.

You can configure Siebel CRM to do calculations with a date and time field in a calculated field. If the user enters a number in a date and time field, then:

  • Integers and hours represent days.

  • Fractions represent minutes and seconds.

For example, to add one minute to the current date and time, you can use the following expression, where one day contains 1440 minutes:

Timestamp() + 1/1440

In this example, Siebel CRM adds the product delivery interval, in seconds, to the current date and time:

Timestamp() + [Product Delivery Interval]/86400

You must set the Type property of the calculated field to DTYPE_DATETIME or DTYPE_UTCDATETIME.