getting records older than 30 days from the current date

[TESS_GEAR]

I am using MS SQL 2000 how can I fetch the data which are older than 30 days from the current date? i set currendate field to "datetime" as a data type and length is "8"

<cfset variables.getdate = DateAdd('d',-30, now())>

select dataname
from tabletest
where currendate >= 'variables.getdate'

the above sql stmt does not work.

[The_ScareCrow · Accepted solution]

select dataname
from tabletest
where currendate <= #CreateODBCDate(dateAdd("d", -30, Now()))#

You say you want records that are older than 30 days from now, thus it should be less than or equal to the date
But if you want records from 30 days ago till now then it should be greater than or equal to

Ken

[Dan_Bracuk]

Change variables.getdate to getdate, or whatever the name of the mssql function is that returns the current date and time. You don't need cold fusion variables or functions for this.