How to delete record after x days

[dawilis]

Any one suggest how I get my code to automatically delete all records in the d/b that are older than x days, and how should I implement this code in my site? ie where would this code be inserted?
Or should I just filter the records by date and let them all build up in the database?

[ecnarongi]

How are you keeping track of how old a record is? By a seperate field? if so you can use 'Now()' which is today's date and if a date is older than X days old call your delete routine.

use:

DateDiff("d", nameofrecord, Now())

which gives you back a number and if that number is greater than or equal to the number X days delete that entire record

if you need me to give code I will, but I don't think I need to

[dawilis]

Ok thats helpfull, thanks, where exactly would one insrt this code in regards to the entire site? I dont want to compamise speed on the front page, is there a way of automatically calling a routine based on time of DAy? say have a seperate page run automacally every day.

[raf]

Yes it is.
See the thread : schedduling executions.