Member Avatar for arunasingh

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/2009.so 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

  • 2 Contributors
  • 1 Reply
  • 83 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Comatose
Member Avatar for Comatose 
dim somedate as string
somedate = "2/3/2009"
parts = split(somedate, "/")

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

     combo1.additem(mymonth)
     combo2.additem(myday)
     combo3.additem(myyear)
end if
commented: Nice +6
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.