Setting validation on day in a date field

[stevey03]

Hi

I want a table to validate a field so that any date it returns cannot be a saturday or a sunday.

I really am stuck on how to dod this. The tableis a table about loaned books, and the field is date due back. I have already set this to default as 1 calender month after the date borrowed using Dateadd("m",1,Now()) but don't know how i could create a validation that works.

Hope someone can help/advise, I would be very grateful,

Forgot to mention that the field displays the date as dd/mm/yyyy followed by time if you click it to modify it

 

[Russell Hauf]

This is kind of crude, but you could replace your default value of

• =DateAdd("m",1,Now())

with:

• =DateAdd("m",1,Now())+IIf(Weekday(DateAdd("m",1,Now()),2)=6,2,IIf(Weekday(DateAdd("m",1,Now()),2)=7,1,0))

However, if you are not entering dates directly into the table (so if you're using a form), then I might use a custom function to handle the date.

Hope this helps,

Russell

 

[stevey03]

Thats done it. Thank you very much I really needed to get that sorted. I was thinking along the lines of a validation rule but thats better.

Thanks again!