Field Validation on Day of week 1

[Bandenjamin]

Hey all,

I've got a table that has a date field that I need to be an "end of week" date (basically Saturday). I need to make sure that no one enters anything in to that field other than a day that is a saturday.

I've tried setting up a validation rule

Weekday(7)

But It did not work. I also tried basing it off other days but apparently no date is valid.

Management requires that this date field be in a mm/dd/yyyy format.

Any help is greatly appreciated.

Thanks,

--Dan
Whenever you find yourself on the side of the majority, it is time to pause and reflect.
Mark Twain

 

[PHV]

Use a table validation rule:
Weekday([your date field])=7

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Bandenjamin]

Thanks PHV, I already knew that it must be Monday and I need more coffee!

--Dan
Whenever you find yourself on the side of the majority, it is time to pause and reflect.
Mark Twain