In "privileges, how to block access to a record (or records) after X days.

Posted on 2007-10-03
Medium Priority
Last Modified: 2010-05-18
I am setting up user priveleges in a FMP Database that allows the user to create new records and have full access to the new record except "delete:" However, the intention is that after "X" days, the record becomes "read only" to all except the Admin account.

I have tried the following formula with no success:

order date <= get (current date) - 5

This does not restrict the records to read only after five days - or have any other effect.
Can anyone out there help me with a workable formula/calsulation?
Question by:DonEnnio
1 Comment
LVL 28

Accepted Solution

lesouef earned 2000 total points
ID: 20009527
wrong way!
order date >= get (current date) - 5

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Integration Management Part 2
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question