How do I do a query that searches for a range up to and including a date? I have this: Queue = 'CustomerCare' AND ( ( LastUpdated < '2007-04-07' AND LastUpdated > '2007-04-01' ) OR ( LastUpdated = '2007-04-01' AND LastUpdated = '2007-04-07' ) )
But it's returning 0 results. If I change the 'OR' to an 'AND' it still returns 0. Using '>=' and '<=' doesn't work either. Mathew Mathew Snyder wrote: > My query: > > 'Queue = "CustomerCare" AND ((Status = "open" AND LastUpdate > $startDate) OR > (Status = "resolved" AND Resolved > $startDate))' > > This, unfortunately, returns all resolved tickets (I'm not sure what it > returns > for open tickets). How can I modify this to only return tickets that are open > and updated according to the date held in $startDate and/or are resolved and > have been resolved according to the date held in $startDate? > > For the record, the date is one week prior to the day the script is run. > > Mathew > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
