I have a problem with dates in queries.
From: P Van Veen (ppvanveen_at_sympatico.ca)
Date: 06/30/04
- Next message: Grant: "Average of last 5 results"
- Previous message: Leif: "Re: UnMatched query"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 29 Jun 2004 21:04:57 -0400
SELECT Schedule.ScheduleDate, Customers.ContactLastName,
Customers.BillingAddress, Customers.City, Customers.PhoneNumber,
Workorders.Make, Workorders.Model, Workorders.ProblemDescription,
nz(DateValue([ScheduleDate])) AS DateCheck, Weekday([ScheduleDate],2) AS
WeekDay, Schedule.WorkorderID, Schedule.EmployeeID, Schedule.Notes,
Customers.Ext, nz(DLookUp("ScheduleDate","Date Check"),Date()-1) AS
LastSched
FROM Customers INNER JOIN (Schedule LEFT JOIN Workorders ON
Schedule.WorkorderID = Workorders.WorkorderID) ON Customers.CustomerID =
Schedule.CustomerNum
WHERE (((nz(DateValue([ScheduleDate])))=DateValue(Date())) AND
((nz(DLookUp("ScheduleDate","Date Check"),Date()-1))<Date()))
ORDER BY Schedule.ScheduleDate;
When I run this query I get a Data Type Mismatch Error. If I remove this
portion of query it runs
OK --------------------------------------------WHERE
(((nz(DateValue([ScheduleDate])))=DateValue(Date()))
Thing is it was running just fine for last 3 years on multiple machines. I
have exported database objects to a fresh database and same problem. I have
also tried running on another machine where and it still fails???
Any help would certainly be greatly appreciated!
Pete Van Veen
- Next message: Grant: "Average of last 5 results"
- Previous message: Leif: "Re: UnMatched query"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
