Re: [CFTALKTor] Date function

[Alan Goldberg]

I do this often. Create a variable with the date required:       <cfset newacctdate = "{ts '" & dateformat(now()+60,"yyyy-mm-dd") & " 00:00:00'}"> Then create your select:     select *     where date_of_account > #newacctdate#   ----- Original Message ----- From: Mike To: [EMAIL PROTECTED] Sent: Sunday, May 19, 2002 12:00 PM 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