Datetime parameter in KPI Delete query
We have KPI objects in which we need to retain data for some period of time lets say, I want to retain data for the last 24 hrs and delete the remaining KPI data. I have prepared KPI query in delete mode. In Filter Expression field of the query i am passing the expression as
"[TimeStamp] <= to_date ( '01/12/2015' , 'MM/DD/YYYY') "
then i am getting the following error:
SQL error has occurred on query The SQL statement "DELETE FROM MDO11061 WHERE FIELD2 <= to_date ( '01/12/2015' , 'MM/DD/YYYY')" contains the syntax error[s]: - 1:46 - SQL syntax error: the token "(" was not expected here
Is it possible to perform such function in the Delete mode of KPI query. If yes, what am I doing incorrectly ? Has anyone faced similar issue earlier.
I would highly appreciate any hint which could help in solving this problem.
NW 7.31 SP 10
MII 14.0 SP5 patch 7
Try using [Timestamp] > [Param.1]. In the parameters tab specify the parameter and type as timestamp.