Jim, Shouldn't your condition be: 'Target Date' > $TIMESTAMP$ AND 'Target Date' <= $TIMESTAMP$ + 60*60*24 which is equivalent to 'Target Date' > $TIMESTAMP$ AND 'Target Date' <= $TIMESTAMP$ + 86400
The above condition would bring all results where the 'Target Date' is greater than the current time, but less than 24 hrs later which gives you the result set you are seeking. Also please make sure you have an index on 'Target Date' if you are going to run this kind of a search else when your record count reaches are few hundred thousands, you won't have too much fun waiting for the results of that search.. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of James Collins Sent: Friday, September 07, 2007 5:10 PM To: [email protected] Subject: epoch formula It is late on a Friday my brain is a bit fried...or getting old...anyway, trying to do a simple thing, I am trying to set up a query that shows tickets about to escalate in one day... So time date field (target date) - 60*60*24 < target date. I am hoping this shows me what is going to escalate or exceed target tommorow. Thanks, Jim _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
