Date Value: Week Begin

B

Bernie

I'd like to use an expression to identify the Week
Beginning date (using Monday) of a given entered date
value.

Users can enter any day of the week, but I would like to
translate that to the Monday date.

Bernie
 
J

John Spencer (MVP)

Use the DateAdd function.

DateAdd("d",2-Weekday([SomeDate]),[Somedate])

Sorry, I can't be any more specific that that.
 
B

Bernie

Worked great! Thanks!
Bernie
-----Original Message-----
Use the DateAdd function.

DateAdd("d",2-Weekday([SomeDate]),[Somedate])

Sorry, I can't be any more specific that that.
I'd like to use an expression to identify the Week
Beginning date (using Monday) of a given entered date
value.

Users can enter any day of the week, but I would like to
translate that to the Monday date.

Bernie
Click to expand...
.
Click to expand...
 
Top