To assign both a date and a time you use this format: : Time « Data Type « VBA / Excel / Access / Word






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

To assign both a date and a time you use this format:

 
Sub main()
    Dim datTime As Date
    datTime = #6/30/1998 3:20:15 AM#
End Sub
Sub dateDemo()
    Dim datPayBy As Date
    
    datPayBy = Date + 60
    
    Debug.Print "Payment is due by " & datPayBy
End Sub








Related examples in the same category

1.Time returns A Variant/Date containing the current time according to your computer
2.Displaying the current date and time in a cell