Hello, I get the following error:

"Data type mismatch in criteria expression"

Where I try to run the following SQL Statement:


strSQL = "SELECT InterviewAvailability.InterviewAvailabilityID, InterviewAvailability.UserAccountID, UserAccount.FullName, UserAccount.Username, InterviewAvailability.AvailabilityDate, InterviewAvailability.StartTime, InterviewAvailability.EndTime, InterviewAvailability.UnavailableTypeID, NonAvailableType.NonAvailableType, InterviewAvailability.Confirmed, InterviewAvailability.Other FROM UserAccount INNER JOIN (NonAvailableType INNER JOIN InterviewAvailability ON NonAvailableType.NonAvailableTypeID = InterviewAvailability.UnavailableTypeID) ON UserAccount.UserAccountID = InterviewAvailability.UserAccountID WHERE (((InterviewAvailability.AvailabilityDate)= ' # mdatShiftDateFilter # ') AND ((InterviewAvailability.StartTime) " & mstrShiftTimeFilter & " ) AND ((InterviewAvailability.Confirmed)=True));"

I think I am having trouble getting the variable right for the mdatShiftDateFilter which is Datetime data type.

Please any help is appricated.

Thanks in advance,
Mark

(InterviewAvailability.StartTime) = " & mstrShiftTimeFilter & " )

And is this a date time field too?

Yes it is a date field. But I am passing in < 5:00 PM, I pass it all in a string statement. The query works fine if I replacemdatShiftDateFilter with #01/10/2005#.