Hi,

i got a problem about the comparsion of date inside a SQL statment .

example:

sqlset = "Select * from Redembuffer where RedemDate = " & inputdate

Which RedemDate is in Data Format ;
and inputdate is a variable which user input, and i would like to compare the date. But i can't get any result afterwards. Can anyone give me some advise?

Wai