paul.hartland at fsmail.net
paul.hartland at fsmail.net
Thu Mar 31 04:09:38 CST 2005
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