Share via

validation rule working on weekday

Anonymous
2018-04-10T15:32:55+00:00

Hello ,

So I made a table on access 2016 and there is a field that should type a date BUT I want the date should be a Monday and  Friday only .

Anyone can help please ?

Thanks in advanced

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2018-04-10T16:56:29+00:00

Have you tried something like this as a validation rule (substituting you field name)?

    [DateField] Is Null Or (Weekday([DateField],1)=2 Or Weekday([DateField],1)=6)

Was this answer helpful?

1 person found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-04-11T17:39:23+00:00

    this worked fine with me

        [DateField] Is Null Or (Weekday([DateField],1)=2 Or Weekday([DateField],1)=6)

    Thanks a lot

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-04-10T17:16:58+00:00

    Thanks a lot .

    It worked

    Was this answer helpful?

    0 comments