In my AccessDB the column monthDate having data type: “date”. In VB6.0 label.caption is the value which I need to save in monthDate.

Like: Label1.caption= 2/24/09.
Problem is how will I convert the label.caption as date value so that i can save it in monthDate column.

I don’t want to change the data type of monthDate column coz lot of reports to be generated on date reference.

Can any one help me please???

regards

label1.caption = date

you need to parse the value before passing the same into database.

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.