Question

CurrentDateTime OQL

2

I am trying to use the DateDiff expression in a OQL query however the syntax seems to be wrong. where DATEDIFF (DAY, Planned_Submission_Date, [%CurrentDateTime%]) <= 14 I get an error at the square bracket of the currentDateTime token. Telling me: "no viable alternative at input '[' please help

asked 2011-02-28

Karol

2 answers

0

'[%CurrentDateTime%]'

answered 2011-02-28

Michel Weststrate

Jonathan Veldhuizen · Accepted Answer · 2011-02-28

Tokens have to be written as a character string:

where 
DATEDIFF (DAY, Planned_Submission_Date, '[%CurrentDateTime%]') <= 14