C
CMA
I'm conceiving of a validation rule that allows users to enter a date no
earlier than the first day of the previous month while the current time is
within the first 7 days of the month. Otherwise, for days 8 to 31, the only
valid date that can be entered must be within the current month (and not a
future date).
I think of it as an "IF" statement, but would like to enter it as a one-line
validation rule.
In other language, I want to do this:
If today is within the first seven days of the current month, then:
You are allowed to enter a date up as far
ago as the first day of last month, up to today
Else
You must enter a date up to as far as the first day of the current
month,
up until today.
My users enter this date onto a form - once this date is entered, it cannot
be modified.
earlier than the first day of the previous month while the current time is
within the first 7 days of the month. Otherwise, for days 8 to 31, the only
valid date that can be entered must be within the current month (and not a
future date).
I think of it as an "IF" statement, but would like to enter it as a one-line
validation rule.
In other language, I want to do this:
If today is within the first seven days of the current month, then:
You are allowed to enter a date up as far
ago as the first day of last month, up to today
Else
You must enter a date up to as far as the first day of the current
month,
up until today.
My users enter this date onto a form - once this date is entered, it cannot
be modified.