I am Developing one Package for international usage. My Package uses
DATE datatype in lot of fields in databases.
In the Coding, I am following #mmm-dd-yyyy# format, which is a
recommended format for Internationalization.
But, I have to form this format, based on the selected values from the
combo boxes. It gives an Error "Runtime Error 13" - "Datatype Mismastch"
My code is...
Dim StartDate as Date
StartDate = CDate("#" & cbo_Month.Text & "-" & cbo_Day.Text & "-" &
cbo_Year.Text & "#")
will leads to "Data type mismatch" error.
Could anybody able to do something for this problem.
I need this very immediately please.