We have an application where we are trying to copy old appointments to
a history table on a nightly basis at 2:00 am.

In SQL 2000 Enterprise Mgr, Managment, Jobs we've created a job with
just one step.
The step is of type TSQL and the command is as follows:

INSERT INTO TempAppt
SELECT * FROM MasterAppt

This works well for copying all the records, however, when i add a
WHERE to the command I get no records at all.

INSERT INTO TempAppt
SELECT * FROM MasterAppt
WHERE MasterAppt.ApptDateTime < DATE

ApptDateTime is set as datatype datetime

When i tried the same sql line in an Access query, it worked fine.
Hence the confusion.

TIA

Guess you are using the wrong function to evaluate the current data (if
you want to use the current date):

INSERT INTO TempAppt
SELECT * FROM MasterAppt
WHERE MasterAppt.ApptDateTime < GETDATE()

HTH; jens Suessmeyer.

I think this is what you want

INSERT INTO TempAppt
SELECT * FROM MasterAppt
WHERE MasterAppt.ApptDateTime <
DateAdd(day,Datediff(day,0,GETDATE()),0)

Madhivanan