Hello!
I have this query:
SELECT [namefield] from [nametable] where date1> #"&Date()&"#
Thia query has to return the [namefields] that have date1 greater than current date. Instead of this it returns all the namefields of the table. Even the namefields that have date1 less than current date. I cant explain why.
I would appreciate any help because I am quite confused
Thanks

I assume you are using MsAccess as your database. Otherwise you wouldn't use # signs. Try setting a variable for Date() and see what happens as follows...

MyDate = Date()
"select FIELD from TABLE where Date1 > #" & MyDate & "#"

Thank you for your suggestion. But it does not seem to work.
From what I have understand the query SELECT [namefield] from [nametable] where date1> #"&Date()&"# returns the namefields that have month > the number of current day. ie
if date1=15/2/2004 and Date()=1/3/2004 then this condition return the namefield but this is wrong.
if date1=15/2/2004 and Date()=3/3/2004 then does not return the namefield. The date has short format DD/MM/YYYY

Your date format is a little different than the standard format I had. Try this.

ThisDate = Date()
MyDay = Day(ThisDate)
MyMonth = Month(ThisDate)
MyYear = Year(ThisDate)
MyDate = MyDay & "/" MyMonth & "/" & MyYear

"select FIELD from TABLE where Date1 > #" & MyDate & "#"

perhaps even...

"select FIELD from TABLE where Date1 > #" & cDate(MyDate) & "#"