[rt-users] Not Updated called in x Days

[Matt Pounsett]

On 11-May-2005, at 15:50 , Lee W wrote:

> Hi Everyone,
>
> I wonder if anyone would be able to help.
> Is it possible to compose a query with a variable date. For example:-
> All calls where status=open and lastupdates <= 2 days ago (or maybe  
> TODAY-2). or are the searches limited to fixed dates.

Whether or not this will work depends on the context in which you're  
working, but if it's in a context where you can embed perl code, you  
can make a call to time() to get the current epoch, and work from there.

Two Days Ago == { time() - (60*60*24) }

Matt Pounsett


-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20050512/fb09d4e9/attachment.sig>