Create Date type variable : Date Type « 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 » Date Type

Create Date type variable

 



Sub DateTest()

    Dim datDec      As Date

    Dim datMay      As Date

    datMay = #5/1/1998#

    datDec = #12/1/1998#

    Debug.Print DatePart("m", datDec)

    Debug.Print DateDiff("m", datMay, datDec)

    Debug.Print "August is " & DateAdd("m", 3, datMay)

End Sub

Related examples in the same category

1.	Variables of type Date must have their values enclosed in # signs
2.	Date Constants
3.	Date value calculation
4.	Try It Out-Dates
5.	Times
6.	Date and Time Functions

www.java2java.com | Contact Us

All other trademarks are property of their respective owners.