Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

current date / month

Status
Not open for further replies.

ruudvdmeer

Technical User
Mar 10, 2005
2
NL
How do I get the current date?
I also like to know which month it is with Visual Basic!
 
Hi ruudvdmeer,

Use Date

Try Month(Date) for the month number
Or Format(Date,"mmm") for the abbreviated month name
Or Format(Date,"mmmm") for the full month name

Or look in Help

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top