Re: [Rt-devel] Current time

[Viktor]

-----Original Message-----
From: "Munoz, Alvaro" <alvaro.munoz.sanchez at hp.com>
To: <rt-devel at lists.bestpractical.com>
Date: Tue, 26 Jun 2007 00:00:12 +0200
Subject: [Rt-devel] Current time

>  
> Hi all,
>  
> is there any variable i can use to check current time.
>  
> I would like to make a query like:
>  
> Query   => " Owner = '__CurrentUser__' AND ( started  > '__CurrentTime__' ) AND ( Status = 'open') AND (queue ='test_queue')",
>  
> But I dont know the right variable.
> Actually what Im really interested in obtain is all tickets opened and not resolved for more than 20 days.

Please try

started > '20 days ago'

condition. Actually Date::Manip is used for date/time parsing, it recognizes almost any imaginable formats.

> Any hints?
>  
> Thanks!
>  
> Alvaro MuЯoz SАnchez
> 
> 
> _______________________________________________
> List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
>