Validation Rules in Tables - Re: Dates

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

Hello!

Does anyone know how to set a validation rule in tables for dates. I would
like to reject date entries being made into a table that are not on a
Saturday. I can't seem to get this to work from the builder. This is the
validation rule I have set already but this doesn't seem to work:-

'Weekday(7)'

Any help would be appreciated.

Regards,
Bruce Holburt
 
Try a validation rule of:

Weekday([MyDate]) = 7

where "MyDate" represents the name of your field.
 
Back
Top