Secure records based on a date range

[Gregory_I]

I am trying to limit access of some users to certain records based on a date range.

In a calculation I would like to specify a date range of 90 days prior to todays current date and 30 days ahead of todays current date.

I tried:

> get(current date)-90 and < get(current date) +30

This did not seam to work very well. I am sure there is a way to do this.

Any help is appreciated.

Thanks

Greg

[comment]

Try =

Let ( 

diff = YourDateField - Get (CurrentDate)

;

-90 < diff and diff < 30

)

[Steven H. Blackwell]

I am trying to limit access of some users to certain records based on a date range.

In a calculation I would like to specify a date range of 90 days prior to todays current date and 30 days ahead of todays current date.

I tried:

> get(current date)-90 and < get(current date) +30

This did not seam to work very well. I am sure there is a way to do this.

Any help is appreciated.

Thanks

Greg

OK, there must be a creation date in each record, preferably automatically entered when the record is created. Then compare that date to your range. If the record falls within the date range range, users in the given Privilege Set can see it. If it does not, then they cannot see it. These access tests are Boolean. They must return a true result in order for the user to see the records.

If you have a large record set, this can be slow over the Local Area Network.

Steven

[Gregory_I]

Thank You!