Do more with
XMonth= Right("00" & Month(Today), 2)
XMonth = Today.Month.ToString("00")
Open in new window
That will result in, for example 12 for december, 05 for may (not 5), 01 for june, etc?
XMonth = Today.Month.ToString().PadLeft(2, "0"c)
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.