Automatic Deleting of Records by Creation Date

[luffo]

For a solution which requires strict complaince with the Data Protection Act I require all records which are 5years older or greater to be deleted automatically when a script is activited.

I need Filemaker to calculate 5years or greater to the DAY not simply just 5 YEARS old going by the year

The script I have been playing about with looks a bit like:

Get ( CurrentDate ) < Client::created_date - Year ( 5)

Delete Record/Request [No Dialog]

End If

Obviously this script doesn't stand a chance but I am getting desperate!

[comment]

See here.