Lock file after 2 weeks

[redballoon]

I would like to lock a users records after 2 weeks,

so in the Priveleges section on the record tab I have limited the priveleges so that initialy only a person who created the record can edit it, I would then like to limit the time they have to 14 days.... I have got this far...

creator = Get(AccountName) + date Entered ≤ GetAsDate ( text ) + 14

Of course this does not work ! but I think you can see what I am trying to do ?

can anyone help here ?

Thank in advance....

[David Jondreau]

+ is a mathematical function. AND is a logical operator. "Date Entered" should be an auto enter field for the Creation Date and "Creator" an auto enter field for the Creation Account name.

Able to Access:

( Creator = Get(AccountName) ) AND ( Date Entered + 13 >= Get(CurrentDate) )

[redballoon]

OK thanks got that bit but how to lock a record a record now fter a period of time so it can be viewed or copied but not altered...

[redballoon]

Thanks, so how would I include hat logical operation to lock a file after the specified time ??