Calculation with timestamp() in siebel query language
Hi fellow experts,
So I need to run this query:
field "Created" is in the last 2 hours
I need this query in 2 different places:
- A Search Specification expression for a Workflow Process Batch Manager server job
- a query expression for end user in the Siebel GUI
I'm actually struggling with the syntax.
in the GUI, I can't get the minus 2 hours working.
I'm stuck here and it doesn't work:
(GUI) Created >= (TimeStamp() - ((1/24) * (2)))
siebel throw an error about grammar rule / unexpected token.
Any thoughts?
Cheers,
Matthieu