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
 
Ad

Advertisements

Ad

Advertisements

R

Ryan

-----Original Message-----
=DatePart("m",Date())-1
.
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


Top