SELECT * FROM table
WHERE datefield BETWEEN #LSParseDateTime(date1)# AND
#LSParseDateTime(date2)#
Book: SQL for smarties - Joe Celko
Steve
> -----Original Message-----
> From: Willy Ray [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 08, 2000 20:41
> To: CF-Talk
> Subject: date comparisons
>
>
>
> One of the fields in my table is a datestamp. I need to be able
> to pull only those records whose datestamps are between certain
> dates. I would like to limit my query to only pull the records I
> need based on their dates, but frankly this app will be getting
> low enough usage that if I could pull all records and then
> evaluate whether or not to print them, that would be fine, too.
>
> Second question: Is there a good simple sql book that I could
> get that would keep me from having to bug the smart people
> everytime I can't figure out some stupid syntax problem?
>
> Willy
>
> ------------------------------------------------------------------
> ------------------------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
