Taleo OTBI Performance Tile Filter : How to get difference between 2 dates

Summary

Taleo OTBI Performance Tile Filter : How to get difference between 2 dates

Content

Hi,

 

Currently, when I try to put a OTBI filter to get difference between 2 dates, it throws syntax error:

"

Formula syntax is invalid.

[nQSError: 10058] A general error has occurred. (HY000)

[nQSError: 43113] Message returned from OBIS. (HY000)

[nQSError: 22023] An arithmetic operation is being carried out on a non-numeric type. (HY000)

SQL Issued: SELECT "Submission CSW Status - Historical"."Historical Status Event Date"-"Requisition Dates"."First Fully Approved Date" FROM "Recruiting"

OK (Ignore Error)

"

 

I have put a 'New View' as a Performance Tile and in 'New Calculated Measure; , aggregation rule as 'Sum'.