RE: [CFTALKTor] Date function

[Mike Lau]

try this: SELECT account_number FROM[Table_Name] WHERE datediff(d, date_of_account, getdate()) > 60   ============================= Mike Lau Web Developer [EMAIL PROTECTED] User In Mind Creative Group Inc. http://www.userinmind.com Toll Free: 1-866-294-6644 T: (416) 490-7556 F: (416) 490-6889 ============================= -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mike Sent: Sunday, May 19, 2002 12:01 PM To: [EMAIL PROTECTED] Subject: [CFTALKTor] Date function Hello All,   I am having a little trouble wrapping my head around the Datacompare or maybe I am using the wrong function.   I have a database (sequel 7) that has has two columns.    account_number   date_of_account 123456                03/01/2002   I would like to bring back only account numbers that have a date_of_account that is greater than 60 days of today's date.   ie accounts listed before march 19 and always comparing to today's date.   Thanks in advance.   Mike