Visual Basic:Convert string to date?

Question

i have three combo boxes to let user enter date(dd/mm/yyyy).how can i combine them into a date?
(using visual basic)

Answer 1

I did a search on ' "Visual Basic" "Convert string to date" ' http://www.google.com/search?hl=en&lr=&as_qdr=all&q=+%22Visual+Basic%22+%22Convert+string+to+date%22

' "Visual Basic" "Converting string to date" '
http://www.google.com/search?hl=en&lr=&as_qdr=all&q=+%22Visual+Basic%22+%22Converting+string+to+date%22

TMD

Answer 2

Hi,
Try the following
-----------------------------------------------------------
Private Sub Command1_Click()
Dim A As String, B As String, C As String, D As Date
A = "25"
B = "09"
C = "2007"
D = A & "/" & B & "/" & C
Debug.Print Month(D)
End Sub
------------------------------------------------------------------------------