Hi -

I have a set of records that I want to delete automatically on a certain (user defined) date. I was thinking of running a script against today's date, and if the current date and the deletion date match, have the record deleted.

My problem is that this database runs continuously and is almost never shut down (which is how I think the Today and Status(CurrentDate) functions get updated).

Is there a script that I can run that every 24 hours will update the current date?

Thanks in advance

Scott

Only the Today function needs to have the database shut down (i.e. doesn't update automatically. This is why I stay away from using it and use Status(CurrentDate) whenever possible.

HTH

Lee

There are a few plugins that will run scripts on time.. Look at http://wmotion.com/events.html

There are a few plugins that will run scripts on time.. Look at http://wmotion.com/events.html

Events is good, but two others well worth considering are:

Troi Activator:

http://www.troi.com/software/activatorplugin.html

Comm-Unity Networking Systems:

http://scriptit.cnsplug-ins.com/

All three are x-plat and each has its own particular strengths and specialities.

They're all shareware, so if you're interested, I suggest that you download free demos from the vendor sites, so that you can try before you buy.