Suppose:

Dim odate as String
odate = "8/7/06 1:30 AM"

How do I get the number of days between Now and odate?

Many Thanks.

Dim numDays as Long
Dim odate as String
odate = "8/7/06 1:30 AM"

numDays = date - int(cdate(odate))


--
Regards,
Tom Ogilvy

wrote in message
ups.com...
Suppose:

Dim odate as String
odate = "8/7/06 1:30 AM"

How do I get the number of days between Now and odate?

Many Thanks.

MsgBox DateDiff("d", DateValue(odate), Now())

" wrote:

Suppose:

Dim odate as String
odate = "8/7/06 1:30 AM"

How do I get the number of days between Now and odate?

Many Thanks.

Thanks guys.

That knocked it out.