First day of week expression

[bluke]

Does anyone know a query expression that would always return the date of the first day of the week (a Monday) for the week after next?

 

[jaydwest]

Try this

MondayNext: date() + (2 -Weekday(Date())) +7
MondayTwoWeeks: date() + (d-Weekday(Date())) + 14

As an alternative, you might want to put the date calculation in a function.

Good Luck

 

[RuralGuy]

Here's a link to put in your favorites: A plethora of date functions