Show Last Month in TextBox?

  • Thread starter Thread starter Bob Vance
  • Start date Start date
Thanks Piet, but its giving me a #Name!
I entered your code in Control Source?
Regards Bob
Trying to show last monthis a text box "Feburary"
=Date()-1"M"

?format(dateadd("m",-1,date()),"mmmm")
 
OK got it Now Thanks
=format(dateadd("m",-1,date()),"mmmm")
Trying to show last monthis a text box "Feburary"
=Date()-1"M"

?format(dateadd("m",-1,date()),"mmmm")
 

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

Month function 6
Monthly Inventory Report 18
Running sum on report 4
Updating the table with query 1
Excel Help with dates 2
IFF (In A Querry) 2
Using TransferSpreadsheet Macro to import a single sheet from exce 1
DCount Dates 2

Back
Top