Haha! Good question. Lemme consult the string theorists and get back to you ;)
Actually, I fixed it by using OR (LastUpdated = '2007-04-01' OR LastUpdated = '2007-04-07') Mathew Ruslan Zakirov wrote: > Mathew, how it's possible that the same date field equal to > '2007-04-01' and '2007-04-07' at the same time? > > On 4/8/07, Mathew Snyder <[EMAIL PROTECTED]> wrote: >> 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 >> > > _______________________________________________ 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
