RE: date comparisons

2000-11-09 Thread Anthony Geoghegan
Hi Willy, SELECT * FROM table WHERE datefield = '#dateformat(date1,"mm/dd/yy")#' AND datefield = '#dateformat(date2,"mm/dd/yy")#' Pulls all data from table between date1 and date2 (inclusive). I found the Books Online SQL refernece an excellent Reference. I can't say I've ever used a tuorial

RE: date comparisons

2000-11-09 Thread Stephen Moretti
s Stephen -Original Message- From: Anthony Geoghegan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 09 November 2000 11:36 To: CF-Talk Subject: RE: date comparisons Hi Willy, SELECT * FROM table WHERE datefield = '#dateformat(date1,"mm/dd/yy")#' AND datefield = '#datefo

RE: date comparisons

2000-11-09 Thread Steve Martin
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