Insert Date field from VB6 into DBF table [sadeyes]

[sane79]

Hi.. I need help with inserting date from vb6 to dbf table..

Currently, this is the code that I'm using... but I get error from VB.. can anyone advise me on this pls?
VB6 with foxpro dbf tables.

INSERT INTO TRANM (TRAN_DATE)
VALUES (" & Format$(dtTranDate, "{#yyyy\-mm\-dd}#&quot & &quot

 

[Bastien]

What is the error? Have you tried to format the date first and then do the insert?

Bastien

Any one have a techie job in Toronto, I need to work...being laid off sucks!

 

[vb5prgrmr]

sane79 have you read FAQ222-2244 yet?

Are you using the ODBC driver? you may then want to pass the fox pro date function as part of your insert string with the values that you want.
[tt]
INSERT INTO TRANM (TRAN_DATE)
VALUES (date(" & Year(dtTranDate) & "," & Format(Month(dtTranDate), "00&quot & "," & Format(Day(dtTranDate), "00&quot & &quot"
[/tt]

The fox pro date function has these parts

Date(Year, Month, Day)


Good Luck

 

[sane79]

Thanks all!
I managed to get it out with this...

sDateFormat = "\{MM\-DD\-YYYY}\"
insert into table (dtTranDate) values (" & Format$(dtTranDate, sDateFormat) & &quot

(-: