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")
 
Back
Top