MSaccess input form question

Hi. I have an input form that asks for a date input. I want to make sure the date entered is a Monday always. What would be the best approach to this. Can I do this in the table as a check or in a form where the date is entered or in a vba function returning back to the form if there is an error? I assume I could use the following function?

DatePart ("w", StartDate)
LVL 1
PawloAAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:
or use the weekday() function, or Format() and ask for the day spelled out, so you can check for "Mon" or "Monday"

Jim.
0
 
PawloAAuthor Commented:
Thanks. Weekday() worked for me.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.