Date Function in VBA?

[hansocool]

So I know there's a date function where you get something like 6/2/2011 if you do date(2011, 6, 2). But it doesn't exist in VBA? I can only use the date function to give the current date.

 

[markmzz]

So I know there's a date function where you get something like 6/2/2011 if you do date(2011, 6, 2). But it doesn't exist in VBA? I can only use the date function to give the current date.

Hansocool,

Try this:

Sub DateTest()
    myDate = [COLOR=blue][B]DateSerial(1999, 2, 23[/B][/COLOR])
    MsgBox myDate
End Sub

Markmzz