Posted by Roy Harvey on 09/13/06 11:08

On Wed, 13 Sep 2006 11:59:46 +0100, "@sh" <spam@spam.com> wrote:

> WHERE DateGiven > '10/09/2006' AND <
>'13/09/2006'

WHERE DateGiven > '10/09/2006'
AND DateGiven < '13/09/2006'

You need to specify DateGiven for each comparison.

Roy Harvey
Beacon Falls, CT

• Next in forum: Re: SQL Between Dates
• Prev in forum: SQL Between Dates
• Thread view: Re: SQL Between Dates

[Reply to this message]