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.