Hello,

I am fairly new to FileMaker but do understand the basics. I need to write

a script which can delete old/aged records. So for example, if there is a

post submitted today (and subsequently a record created for it) then after

7 days (say) I would like the script to delete the record. I looked at

scriptmaker and the various control functions etc. I think I know how the

control structure may look like but am not sure how to check the age of the

record. Any ideas on how this can be done ?

thanks!

In general, it is not a bad idea to include 4 fields in every file:

creation date (auto enter creation date)

creation time (auto enter creation time)

modification date (auto enter modification date)

modification time (auto enter modification time)

These fields will track specific creation and modification date times that you can use in a variety of ways, one of which would be to find and delete records over one week old in a startup script for the file.

-Raz