Saturday

P

PeterK

I would like to have a field default allways to the next
saturday. How do I do this using the Date() function?

THX
 
R

Rick Brandt

PeterK said:
I would like to have a field default allways to the next
saturday. How do I do this using the Date() function?
Click to expand...

Try this...

NextSaturday: DateAdd("d", 8-(Weekday(Date(),vbSaturday)),Date())
 
Top