Taleo OTBI Performance Tile Filter : How to get difference between 2 dates
SummaryTaleo OTBI Performance Tile Filter : How to get difference between 2 dates
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"
I have put a 'New View' as a Performance Tile and in 'New Calculated Measure; , aggregation rule as 'Sum'.