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"

Reply via email to