RE: [CFTALKTor] Date function

[Rob Matlow]

Use cfloop to test the condition for each date_of_account.  If it meets that criteria then display if not do nothing.    Cheers,   Rob ________________________________ Rob Matlow REM Web Solutions [EMAIL PROTECTED] 519.884.4111 or 1.866.754.4111 www.remwebsolutions.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mike Sent: May 19, 2002 12:18 PM To: [EMAIL PROTECTED] Subject: Re: [CFTALKTor] Date function Thanks Rob,   How would I do it to show all the records that meet that criteria?   Thanks   Mike ----- Original Message ----- From: Rob Matlow To: [EMAIL PROTECTED] Sent: Sunday, May 19, 2002 12:05 PM Subject: RE: [CFTALKTor] Date function You could use the dateDiff() function.  You would then be able to find out how many days are between today's date now() and date_of_account.  If the number returned is greater then 60 days then display that account.   ________________________________ Rob Matlow REM Web Solutions [EMAIL PROTECTED] 519.884.4111 or 1.866.754.4111 www.remwebsolutions.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mike Sent: 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