I need the date value like this 08042004...<BR><BR>CurrDate = Date<BR><BR>and how do i make my CurrDate looks like 08042004?
CurrDate = right(0 & Month(date), 2) & right(0 & day(date), 2) & year(date)
try this, dont know if it will work but i've been doing dates all day;<BR><BR>CurrDate = CDate(Date()) 'CDate should give zeros for single dates<BR>Replace(CurrDate, "/","") ' this will take the '/' out of the line<BR>
But Nice try!<BR><BR>(for a guy in wales) ;-)
Aww, heck, what do I know anyway!<BR>