hI.. i am getting the same error.

The thing is ive used this code else where and it didn't give me problems but in this particular case where I have it it does.

Function GetDateFilter(d tDate As Date) As String
GetDateFilter = "#" & Format(dtDate, "DD/MM/YYYY hh:mm:ss AM/PM") & "#"
End Function

The above function is called in the following code.......