only the date part
 

No time component, just the date. This seems a bit much. Is this how
it's done?

Dim dt As Date: dt = Now()
Dim justDate As Date: justDate = DateValue(DatePart("m", dt) & "/" &
DatePart("d", dt) & "/" & DatePart("yyyy", dt))

only the date part
 

Hi,

Am Sat, 23 Mar 2013 07:08:11 -0700 (PDT) schrieb oldyork90:

No time component, just the date. This seems a bit much. Is this how
it's done?

with Date you get only the date of today:
dt=Date


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

only the date part
 

Try

Dim myDate as String

TheDate = Now()
MyDate = Format(TheDate, "M/D/YYYY")

HTH
Mick.

only the date part
 

Le 23/03/2013 15:57, Claus Busch a écrit :
Hi,

Am Sat, 23 Mar 2013 07:08:11 -0700 (PDT) schrieb oldyork90:

No time component, just the date. This seems a bit much. Is this how
it's done?

with Date you get only the date of today:
dt=Date

Or, for any date in dt:
justDate=Int(dt)