CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

How to add "numeric field" to a "date field" in Report?

edited Feb 24, 2014 6:35AM in CRM On Demand - Reports and Dashboards (MOSC) 4 commentsAnswered

Hi,

Good day!

We are currently working with Opportunity Record Type. In the report, we are trying to add "number of days" to a Date field.

Here is our formula:

TimestampAdd (interval, integer_expression, timestamp_expression)

TIMESTAMPADD(SQL_TSI_DAY, Cast("Sales Stage Metrics"."# of Days in Stage" as Integer), Cast("- Stage Start Date".Date as Date))

And we got this error:

View Display Error
Odbc driver returned an error (SQLExecDirectW).

  Error Details  

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 22025] Function TimestampAdd is called with an incompatible type. (HY000)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center