hmmm...
well... if you're thinking of retrieving one single record with your
query, well, unless you are sure you have one and only one record that
has this date value that falls between the startDate and endDate then
you'll be recieving more than one.
Also, knowing which database would help, but here is how I'd do it in
SQl Server 2000
select [someField] from [someTable] where ([dateField] > @startDate and
[dateField] < @endDate)
In Oracle we take advantage of the between keyword
select [someField] from [someTable] where ([dateField] BETWEEN
@startDate and @endDate)
*keep in mind that in Oracle, between includes the startDate and endDate
**@paramName is a parameter name that you pass on to the query.
cheers
got a code problem? hand it to the devil.
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!