Hi,

In my database set up I have a field called start date which is a shortdate datatype.

When I compare the information from a date picker I get a data type mismatch error.

Could you help?

Set rs = CurrentDb.OpenRecordset("SELECT ID, startDate, endDate FROM tblLeave WHERE startDate > '" & dpkEndDate & "'")


dpkEndDate being the datepicker.

Your problem is in using ' around your date. Quotes are for strings.

Use # for dates.... That should resolve your issue(s)

Thanks a lot!

Did not know about #!