Date Validation for Specific Day of the Week
I have a field for a time card. It is set up with a pop up calander. Which works fine. Here is my question. Is there a way to Valadate that it is always a Monday?
It's not a validation calculation. It's an auto-enter calculation.
Copy this calc to the clipboard and then remove it.
Click the auto-enter calc.
Click the calculation button.
Paste the copied expression there.
Clear the "do not replace existing value..." check box.
DayOfWeek ( Date )
will return a value of 2 for a date that falls on a Monday.
You might want to make an entered date auto-correct to be Monday of the same week:
Self - DayOfWeek ( Self ) + 2 // clear the "do not replace existing value..." check box
Thanks for the response Phil, but Im having an issue. I like the the Idea of using the auto correct you mentioned. I can't seem to get it to work. Here is what I am doing.
I have a field called " Start Date" this is a Date Field.
I went under options to Validation.
I checked "Validated by calculation"
I type in:
Self - DayOfWeek ( Self ) + 2
What am I doing wrong?
Thank you!! Works great.
Retrieving data ...