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"