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

1.	Access
2.	Application
3.	Data Type
4.	Data Type Functions
5.	Date Functions
6.	Excel
7.	File Path
8.	Forms
9.	Language Basics
10.	Math Functions
11.	Outlook
12.	PowerPoint
13.	String Functions
14.	Windows API
15.	Word
16.	XML

VBA / Excel / Access / Word » Data Type » 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

www.java2java.com | Contact Us

All other trademarks are property of their respective owners.