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