How can I use >=Date() as criteria in an Access Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to use a query to select only those records where the 'Rollover Date'
is greater than or equal to todays date. >=date() does not work as criteria
in the Rollover Date field? any suggestions
 
Hi BarryS,
If the 'Rollover Date' are defined as Date/Time field, it should have worked.
If they are defined as Text field, then weird result will come up.

Hope this will help.
 
Back
Top