Variables of type Date must have their values enclosed in # signs : Date Type « Data Type « VBA / Excel / Access / Word

1. VBA / Excel / Access / Word
2. Data Type
3. Date Type

Variables of type Date must have their values enclosed in # signs

 
Sub dateSub()
    Dim thisDate As Date
    thisDate = #10/8/2003#
    Debug.Print thisDate
End Sub

 

Related examples in the same category