Silly little problem; I want to have a form text box open with last month showing as default. But I can't get it!
Tried this;
=Format(Now(),"mm")-1
and a couple of others, but nothing seems to make any difference.
Silly little problem; I want to have a form text box open with last month showing as default. But I can't get it!
Tried this;
=Format(Now(),"mm")-1
and a couple of others, but nothing seems to make any difference.

This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
To get the date 1 month before today:
=DateAdd("m",-1,Date())
If you only want to show the month, set the Format property of the text box to a custom format.