Setting value for Textbox

R

Ryan

How can I set the value of a textbox to be equal to one
month prior to the current month?

Thanks,
Ryan
 
R

Ryan

-----Original Message-----
=DatePart("m",Date())-1
.
Click to expand...

That is almost what I need. The only thing is that I need
to be able to display this information as mm/yyyy. any
suggestions? When I change the format of the text button
to this the date come up as 01/1900 because it recognizes
the number 11 not the month November 2003

Thanks,
Ryan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DLookup in Continuous form 0
Incone & Expenses Statement 0
Flag duplicate emails 1
"Linking" an arrow to textbox 1
Dynamic Query from Form 8
Word macro that can call cells out of Excel for a find and replace 0
Differentiating between displayed field value and stored field val 2
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1

Top