P PeterK Feb 13, 2004 #1 I would like to have a field default allways to the next saturday. How do I do this using the Date() function? THX
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 Feb 13, 2004 #2 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())
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())
