Skip to content
Skip to breadcrumbs
Skip to header menu
Skip to action menu
Skip to quick search

Welcome to FreeSoftwareServers Confluence Wiki

Skip to end of banner Go to start of banner

Date Variables - VBA

Skip to end of metadata

Created by freesoftwareservers, last modified on Jul 03, 2020

Go to start of metadata

https://stackoverflow.com/questions/35921124/how-to-get-current-month

Sub Test()
Dim Month As Long, Day As Long, Year As Long
Month = Format(Date, "m")
Day = Format(Date, "d")
Year = Format(Date, "yyyy")
MsgBox Month & Day & Year
End Sub

No labels

This site is just a Tech Blog, nothing is guaranteed!