Identify tickets due within 3 days...?


#1

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.


#2

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?


#3

Hi GreenJimll,

I require tickets that are due in the next 3 days.

So something like: Due > ‘in 3 days’ AND Due < ‘today’

Thanks


#4

Something like:

Due > 'today' AND Due < 'today + 3 days'

Ie the Due date is after today, but before three days after today.


#5

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


#6

Try now instead of today ?