Hi All,
I would like to create a custom search to identify all tickets that are due within 3 days of current date. How would I write the SQL for this search?
Thanks in advance for any help.
Hi All,
I would like to create a custom search to identify all tickets that are due within 3 days of current date. How would I write the SQL for this search?
Thanks in advance for any help.
You mean something like Due > '3 days ago' AND Due < 'today'
in TicketSQL to find tickets due in the last 3 days? Or did you want tickets due from today for the next three days? Or did you mean in “real” SQL in the underlying database?
Hi GreenJimll,
I require tickets that are due in the next 3 days.
So something like: Due > ‘in 3 days’ AND Due < ‘today’
Thanks
Something like:
Due > 'today' AND Due < 'today + 3 days'
Ie the Due date is after today, but before three days after today.
Hi,
I tried this but do not bring back any results. I have a test ticket with a due date of 28/03/19 but this SQL does not return the ticket.
Is there anything else I need to add?
Thanks
Try now
instead of today
?