[rt-users] Query in script not working

Stephen Turner sturner at MIT.EDU
Mon Feb 25 14:24:19 EST 2008


Quoting Mathew Snyder <mathew.snyder at gmail.com>:

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

You are actually getting the tickets you want - the dates are stored in the
database as GMT and so appear different by 5 hours from what you see on the
screen. It looks a bit strange, but it works fine.

BTW - what was the problem that you fixed with the dates?

Steve



More information about the rt-users mailing list