Default Date in m/yy Format to Last Month 1

[Hillary]

I have a field Period in my table which represents the Accounting Peroid. Periods are based on Month/Year. Information entered into this table will usually be for the prior month's accounting period so I want to default the date to last month. For example, if I enter a record anytime during July 03, I want the date to default to 6/03.

Format: m/yy
Default: Date()-1 (this only subtracts 1 day; I want to subtract 1 month)

Thanks for your help!

Hillary

 

[LonnieJohnson]

Try...

=Format(DateAdd("m",-1,Date()),"mm/yy&quot

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!