validating date input by user

  • Thread starter Thread starter NicNel
  • Start date Start date
N

NicNel

I am trying to use VB to check that the date input by the
user on a form is not a Saturday or Sunday. I have tried
a variety of ways, but nothing has worked! Can anyone
help?
 
This is the function I was trying to use, but I must be
doing something wrong because no matter what date I put in
it tells me it is a weekend! I thought it may be looking
at the system date or perhaps it was my formatting but I
tried putting in a date that followed mmddyy to check, and
I still have the same problem.

Any ideas?

Thanks
 
John - Thanks it is all working now, I am not even going
to admit what I did wrong (too embarassing!). I
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation in a Form 2
main form - subform 5
Validation code rule 2
Date Input Mask Question 4
Subform Input Validation 1
validation rule problem 1
Counting Days of Week 2
Validation in child form 1

Back
Top