I've got the dates working. However, the tickets retrieved are still based on the day starting at 05:00:00 and ending the following morning at the same time. How can I tell it to only return tickets from between 00:00:00 and 23:59:00?
Mathew Stephen Turner wrote: > Quoting Mathew Snyder <[EMAIL PROTECTED]>: > >> I'm trying to get all of the tickets which, for any given day, were >> LastUpdated >> 'yesterday'. When I do a search within RT using " LastUpdated = >> '2008-02-24' >> AND ( Queue = 'CustomerCare' OR Queue = 'TechOps' )" I'm shown 8 >> tickets. >> However, when I run the following script I get nothing. >> >> > > Mathew, > > What do you get if you put 'print $yesterday' in your script? Also, > printing > $tix->BuildSelectQuery (after the FromSQL statement) will show you the > actual > sql statement being used, and might be helpful. > > Steve -- Keep up with me and what I'm up to: http://theillien.blogspot.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
