[rt-users] Query in script not working

[Mathew Snyder]

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 <mathew.snyder at gmail.com>:
> 
>> 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