Date Value: Week Begin

  • Thread starter Thread starter Bernie
  • Start date Start date
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
 
Use the DateAdd function.

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

Sorry, I can't be any more specific that that.
 
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...
 
Back
Top