Hi,
I'm trying to find if a specific date appears within a table. The code I am using works if the date doesn't have a leading zero in it e.g. 12/11/2011
strSQL = "SELECT Holidays.EmployeeID, Holidays.Dates, Holidays.Period FROM Holidays WHERE Holidays.Dates = #" & datebooked & "#;"
But when I search for 01/02/2011 it seems the zeros are being removed in the query and therefore the date isn't found in the table when it actual is there!
Any help would be much appreciated.
Thanks,
Andy.