vDay = Day(the_date_variable)

vMonth = Month(the_date_variable)

vYear = Year(the_date_variable)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"snowing" wrote in
message ...

Hello,

Does anyone know how I could take a date like this..

30/05/2006 9:33:03 AM

split it up and store the first part of it in variables. So 30 would be
stored in a variable of its own, 05 would be stored in a variable of its
own and 2006 would be stored in a variable of its own.

Thanks


--
snowing
------------------------------------------------------------------------
snowing's Profile:
http://www.excelforum.com/member.php...o&userid=34576
View this thread: http://www.excelforum.com/showthread...hreadid=558237