On Sun, 29 Apr 2007, Rich Shepard wrote:
How does one define 'shift' with intervals? 0.33 DAY?
On further reflection, I understand how to make the interval 'day' work by comparing the current timestamp with the month and hour. If there's no record within the necessary range, a message is e-mailed to the client noting the deficiency. Thanks all, Rich -- Richard B. Shepard, Ph.D. | The Environmental Permitting Applied Ecosystem Services, Inc. | Accelerator(TM) <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863