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 for it though.
Regards,
Anthony Geoghegan.
Lead Developer,
What's On Where (WOW!)
http://www.wow.ie
mailto:[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]
