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
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
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
3 matches
Mail list logo