\r\n\r\n \r\n \r\n \r\n # 2 \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n  \r\n \r\n 04-01-2001, 01:09 PM\r\n \r\n \r\n \r\n | \r\n
\r\n\r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n | \r\n\r\n \r\n\r\n Guest \r\n \r\n \r\n\r\n | \r\n | \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n Posts: n/a\r\n \r\n \r\n \r\n \r\n \r\n \r\n | \r\n \r\n \r\n \r\n | \r\n
\r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n\r\n \r\n \r\n \r\n  \r\n Re: Date Difference using Date Picker\r\n
\r\n \r\n \r\n \r\n \r\n \r\n | \r\n \r\n\r\n \r\n\r\n\r\n Here is an example of using the DateDiff function. Hope it helps.
\r\n
\r\nEric
\r\n
\r\n
\r\nPrivate Sub Command1_Click()
\r\n
\r\nDim DaysRented As Integer
\r\nDim dtpEnd As Date
\r\nDim dtpStart As Date
\r\n
\r\ndtpEnd = #3/12/2001#
\r\ndtpStart = #3/1/2001#
\r\n
\r\n
\r\nDaysRented = DateDiff("d", dtpStart, dtpEnd)
\r\nMsgBox DaysRented
\r\n
\r\nEnd Sub
\r\n
\n
\n \r\n \r\n\r\n | \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n\r\n \r\n\r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n  \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n | \r\n
\r\n
Date Difference using Date Picker
Threaded Mode
