looking to create a formula or rule to do the following
interior Date Field to not allow changes if interior status is confirmed and less then 2 weeks from current week.
I think the easiest way is to make a formula field called [Lock Interior Date?]
[Interior Status ] = "Confirmed"
and
Todays([Today() - [Interior Date]) <= 10
Then put that field on the form, even in a hidden section and use it in a form rule
Qrew LegendThis can be done with form rules. Can you tell us if you are using new style forms or old style forms?
i believe its the old form ... i have a check box formula however when the status and schedule dates are aligned to trigger the check box .. the check box line flashes a red strike through and does not apply the check off ... (the check off box is my trigger on the form rules to not allow the field to be edited. )
Qrew LegendI think the easiest way is to make a formula field called [Lock Interior Date?]
[Interior Status ] = "Confirmed"
and
Todays([Today() - [Interior Date]) <= 10
Then put that field on the form, even in a hidden section and use it in a form rule
