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 _______________________________________________ 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