Validation

ICTkirsten

Registered User.
Local time
Today, 19:34
Joined
Jan 3, 2015
Messages
137
Hello,

I am trying to create a validation rule for one of my fields.. i want it to be so that the user can not select a date to be on a Sunday..

Any advice would be great.

Thank you

:)
 
While I think it would be preferable to use the ideas in the first post to check for a Sunday and then run code to prevent the date being entered, you could also use the following as a validation rule:

Weekday([DateSelected],2)<7

But then you get an awkward message telling the user that they have made a bad error. That is why I prefer the first method.
 

Users who are viewing this thread

Back
Top Bottom