sir ,

I have an application in that i have 3 dropdown in which i have entered day ,month ,year separately and in database i have stored this date in combined form suppose2/3/ when i want to update this date then how i can do that becoz now date is in combined form how to separate this date in three dropdown

dim somedate as string
somedate = "2/3/2009"
parts = split(somedate, "/")

if ubound(parts()) < 2 then
     msgbox "Error Parsing Date String"
     exit sub
     mymonth = somedate(0)
     myday = somedate(1)
     myyear = somedate(2)

end if
commented: Nice +6