Problem with inserting date field into MySQL with VB6

[sane79]

Hi all.. I have a problem with inserting a date field from VB into MySQL.

The entered value in MYSQL shows 0000-00-00

This is what I have in VB

Dim SDateFormat As String
SDateFormat = "YYYY0-MM-DD"

"INSERT INTO CUSTOMER (DOB)
VALUES (" & Format$(dtDOB, SDateFormat) & &quot"

Can anyone advise me on what is wrong here pls?
Thanks

 

[zemp]

Two things that you can check. First is,

... = "YYYY0-MM-DD"

a typo in the post or in your code? Make sure it is "YYYY-MM-DD".

Second, does the string need to be surrounded by some kind of quotes, as it does in other databases, which may depend on the data type. (I am not familiar with MySQL)? If so try,

... VALUES ('" & Format$(dtDOB, SDateFormat) & "')"

Take Care,

zemp

 

[matzos]

What is the error you are receiving? If you aren't getting an actual error and your result is just an incorrect date in the MySQL CUSTOMER table, what is that bad value?

 

[sane79]

Opps typo mistake on my side..
problem solved!
Thanks!