Jim, You are welcome.. If you are going to use that qualification in some workflow or if you think your users will be running that query often, do not forget to create an index on the field 'Target Date'. Or it could cause performance problems on that search in the long run.
Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of James Collins Sent: Friday, September 07, 2007 5:56 PM To: arslist@ARSLIST.ORG Subject: Re: epoch formula ** Joe, It does look right…thanks to you ad Thad….I just could not think of it. Jim ---------------------------------------------------------------------------- -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Friday, September 07, 2007 5:28 PM To: arslist@ARSLIST.ORG Subject: Re: epoch formula 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: arslist@ARSLIST.ORG 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 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.485 / Virus Database: 269.13.9/994 - Release Date: 9/7/2007 4:40 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"