Bashir, If I was looking for tickets created between 1600 on Friday, January 16th 2009 and 1700 Monday, January 19th, 2009, I would do the following:
In Query Builder use the "Created" field with "After" and the string: Fri Jan 16 16:00:00 2009 And click "Add" to "Add these items to your search. Then with the "AND" operator selected, use "Created" with "Before" and the string: Mon Jan 19 17:00:00 2009 I'm sure the proper formatting of "date/time" fields is in the documentation somewhere, but I got it from the formatting in the "Dates" section of ticket metadata. You can just copy and paste the string from there and modify as necessary. This formatting works for setting reminders as well. Patrick -----Original Message----- From: "Bashir Jahed" <[email protected]> To: <[email protected]> Date: Wed, 28 Jan 2009 15:47:58 +0200 Subject: [rt-users] Custom Search > Hi guys, > > > > I am stuck now.... Please Help... > > > > I need to be able to search for tickets created between 16h00 on a > Friday afternoon and 17h00 on a Monday Morning. > > > > How would I achieve this? > > > > ________________________________ > > bashir jahed > nha | enhance > > > 5 protea road | claremont | 7708 > po box 24 | newlands | 7725 > > > telephone +27 (21) 657-2574 > > mobile +27 (83) 414-0453 > > facsimile +27 (21) 657-2575 > > e-mail | messenger [email protected] > <mailto:[email protected]> > > ________________________________ > > this message is subject to the disclaimer at > www.nha.co.za/disclaimer.asp <http://www.nha.co.za/disclaimer.asp> or > [email protected] > <mailto:[email protected]?subject=request%20disclaimer> > > > > > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
