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.