Drew,
Look up the modulus command (%)....what you need to do is say something like
'Create Date' > <start date> AND 'Create Date' < <end date> AND ('Create
Date'%86400 > 60*60*12)
The 60*60*120 is seconds in a min times min's in an hour times hour of the
day you are looking for. The 'Create Date'%86400 basically divides the # of
seconds in the field by the number of seconds in a day and gives you the
remainder of that division problem...this will effectively be the # of
seconds of that day...
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Drew Shuller
Sent: Tuesday, July 06, 2010 2:17 PM
To: [email protected]
Subject: Date/Time field query
Hello all, is there a way to do a select statement from within a
select statement on field ID 3? I have users that want to know if they
created tickets after a certain hour of the day, for a three month
period. Any ideas? Thank you.
--
Drew
Soto Cano AB
Comayagua, Honduras
____________________________________________________________________________
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
