Working with dates in access rules

Ask for Help
1

Hello.

I have a column with dates. I need to make it so that editors cannot change a row if the month of the date is 2 less than the current month, that is, I need to disable editing of previous periods.

In access rules, you cannot use functions for working with dates like: NOW() > DATEADD(rec.date, montns=2)

How else can I be prevented from editing old rows in the table?

2

Make a formula column that does whatever calculation you need with dates and returns true or false. Then just check that column directly in your access rules.

1 Like