How to prevent users from inputting a record when the [Date] fiels does not fall in the current month. (Prevent a record dated 8/30 from being input on 9/1, for example.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Photo of Barbara

Barbara

  • 0 Points

Posted 3 years ago

  • 0
  • 1
I suggest making a field which calculates if Today is the current month.

It would be a formula checkbox field with a formula. Call it say [Date is during current month]

[My Date Field] >= FirstDayOfMonth(Today())
and
[My Date Field] <= FirstDayOfMonth(Today())

Then have a form rule that says
When the record is saved
and

Date is during current month] Is not checked

Abort the save with message

Sorry, please enter a date in the current month.

You may need to put that field on the form to get the form rules to kick in correctly.