Fred,
Thank you for the quick response, that worked like a charm, thank you
so much.
now how on earth did you ever figure that one out :P
this one is going in my list of 'keep for later use' folder as I know I
will need it.
thanks again!
Michael Hirst
University of Arizona.
CCIT, Account Administration
Ph: 520-621-0867
[EMAIL PROTECTED]
-------------------------
You think you have trouble now....just wait till we get there.
Grooms, Frederick W wrote:
All ticket created between 5pm and 8am on any day:
(((((( 'arrival time' - "1/1/70") % 86400) >= 17 * 3600)
AND ((( 'arrival time' - "1/1/70" ) % 86400) <= 24 * 3600))
OR (((( 'arrival time' - "1/1/70") % 86400) >= 0 * 3600)
AND ((( 'arrival time' - "1/1/70" ) % 86400) <= 8 * 3600))))
AND ('arrival time' > "11/1/2006") AND ('arrival time' < "12/1/2006)
The trick is to subtract a date from your date (which makes it an
integer) and then use the modulus operator "%"
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Michael Hirst
Sent: Wednesday, December 13, 2006 12:32 PM
To: [email protected]
Subject: How to search by time in a date/time field
Hello Listers,
I was hoping someone might give some insight or suggestions on
how to search on time within a date/time field. It seems to be an easy
answer, but is evading me at this time, and while my team is researching
ways to do this by an outside process, I was wondering if it was
possible to do by a search within the application as well.
I have a date/time field called 'arrival time' which shows the dates as:
12/7/2006 7:26:41 AM
but what I need to do is search for a time frame. For example, I want
to find all the tickets that were created between 5pm and 8am for the
entire month of November.
So far my experiments have failed, and I am still researching but wanted
to ask if anyone else had to do this and what your solution was.
thank you,
--
Michael Hirst
University of Arizona.
CCIT, Account Administration
Ph: 520-621-0867
[EMAIL PROTECTED]
-------------------------
You think you have trouble now....just wait till we get there.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
