Showing a specific date

[coach.32]

I have a form that has a textbox which shows today's date. I would like to have another text box that shows only the Monday prior to the current date. Is this at all possible and if so how? Thank-you in advance for any help you may offer.

 

[John Big Booty]

You could use the following as the Control Source for your Text Box;

=[URL="http://www.techonthenet.com/access/functions/date/dateadd.php"]DateAdd[/URL]("d",-[URL="http://www.techonthenet.com/access/functions/date/weekday.php"]Weekday[/URL]([YourDateField],2)+1,[YourDateField])