Parameter Date - Force a Monday Date

[ker9]

Hi, Is there a way to force a user to either choose a Monday as the start date or to calculate the next Monday from an entered start date so that the query always begins on a Monday?
Thank you.

[RuralGuy]

I'll bet you can fine what you want on this link: http://www.pacificdb.com.au/Support/code_datetime.htm

[ker9]

Thank you - that was helpful.
This gets me the next monday.

DateAdd("d",8-Weekday([dte],2),[dte])

I've been trying to add an IIF statement to it that will determine if the parameter date entered is a Monday, use that date, if not get the next Monday.

I don't understand the syntax and can't get it..

DateAdd("d",IIf(Weekday([dte],2)=2,2,8-Weekday([dte],2)),[dte])

Thanks for any assistance.

EDIT:
I got it!

IIf(Weekday([dte])=2,[dte],(DateAdd("d",8-Weekday([dte],2),[dte])))

[RuralGuy]

Excellent! Thanks for posting back with your solution.