Help with SQL Syntax...

  • Thread starter Thread starter Louie Warren
  • Start date Start date
L

Louie Warren

I have a query that checks for a date range...

When I enter the following, I am prompted for each date
and I get correct results:

Where Date Between [Enter Start Date] AND [Enter End
Date]

When I put the dates in place of the prompts, as below, I
get no results:

Where Date Between 02/01/04 and 02/28/04

How can I do the later and get results? Please advise.

L
 
Date literals in SQL statments need to be delimited by "#" characters, so
you might try

Where Date Between #02/01/2004# and #02/28/2004#

instead.
 
Back
Top