[AccessD] Check To See If Employee Has 19 hour Window Between jobs

Try...

abs(DateDiff("h", firstdatetime, seconddatetime)) <= 19

Scott Marcus


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
paul.hartland at fsmail.net
Sent: Thursday, March 31, 2005 5:10 AM
To: accessd
Subject: [AccessD] Check To See If Employee Has 19 hour Window Between
jobs

To all,

I have an availability table for an employee which some of the fields
are PayrollNo, JobDate, StartTime, JobNo.  When assigning a person to a
job I need to get the availability record for the previous day and day
after to make sure that the employee has a 19 hour window between jobs.
So basically what I need to do is say someone is assigned to a job on
31/03/2005 with a start time of 21:00 I need to get the records for the
30/03/2005 and 01/04/2005 and check that the difference is greater than
or equal to 19 hours.

Anyone any ideas on how to do this easily, sorry if I have confused
anyone I'm not very good at explaining myself at times.

Thanks in advance for any help on this...

Paul Hartland

-- 

Whatever you Wanadoo:
http://www.wanadoo.co.uk/time/

This email has been checked for most known viruses - find out more at:
http://www.wanadoo.co.uk/help/id/7098.htm
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com