query = > today ?

[Glenn]

I'm trying to create a query that will show only the records that has a date
of today or after in the date field (consequently my results would change
everyday).

I tried >=#today# but that didn't work.

Is there a way to do this? If so how?

Thanmks.

 

[SteveS]

I'm trying to create a query that will show only the records that has a date
of today or after in the date field (consequently my results would change
everyday).

I tried >=#today# but that didn't work.

Is there a way to do this? If so how?

Thanmks.



Try

= Date()

 

[Douglas J. Steele]

= Date()

 

[Glenn]

Thank you both!