Validation

[ICTkirsten]

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

 

[Eljefegeneo]

https://support.microsoft.com/kb/290152/en-us/

Not to be one who would say search first, but this was easy to find.

 

[Eljefegeneo]

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.