system date in query builder

Dear all,

I need help to write a query to return all the open interactions from today. I did this but everiday I to go query builder and change the date to reflect to the present day.

here is my query

(open~="Closed") and ( open.time>='12-09-2016 00:00:00' and open.time<='12-09-2016 21:00:00')

 

How can I replace these open.time with the present date. I tried these sysdate, sys.date, (open~="Closed") and ( open.time>=tod() and open.time<=tod()) but nothing is working. My datasource are Interaction - incidents.

Regards,

Parents Reply Children
No Data