The VBA DATE Function

Related Functions:
VBA Time


The VBA Date Function simply returns the current date. The function takes no parameters and therefore, its syntax is:

Date( )

VBA Date Function Example

A simple example of the VBA Date function is shown below:

' Store the current date in the variable currDate
Dim currDate As Date
currDate = Date( )

After running the above VBA code, the variable currDate is set to the current date.