Format Function In VBA

[Transformer]

Hi snb,

There is a difference.Check the following code:

Sub Test()
    
    Dim dteToday    As Date
    Dim strToday    As String
    
    dteToday = Format(Now())
    strToday = Format$(Now())
    
    MsgBox dteToday & vbTab & TypeName(dteToday) & vbNewLine & strToday & vbTab & TypeName(strToday)
    
End Sub