[rt-users] Time Based Query

[Rejo Zenger]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

++ 06/04/05 12:04 -0400 - Thomas Earl:
> Status = 'new'  AND Created < '-1 days ago'  AND Created > '-3 days
>ago' 
>
>... shows me all the tickets new created between a day and 3 days ago. 
>If I change the days to hours, I think I should get all the tickets that
>are new between 1 hour and 3 hours ago, but I get nothing. 

I do the same quite regularly, but with a different syntax:

  Created < '-1 hour'  AND Created > '-3 hour'

Note that I have left out "ago" and use "hour" instead at "hours".

- -- 
Rejo Zenger <rejo at rz.xs4all.nl> - http://rejo.zenger.nl - PGP 0x75FC50F3
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQFCVExpHa9Q5nX8UPMRAs2cAJ0eLsCgEA80YHNxcbOG0JP2OcBiRQCg7440
XQLVsDa+9Lxr6LOZlcHHQCs=
=7+em
-----END PGP SIGNATURE-----