problem in insert query for date

[andypower]

hi
my self andy, i am developing one application in vb 6 and sqlserver 7 as back end. i write one insert query for inserting one record. there is one voucherdate fied. to which i am passing my date value as a parameter. bu when i execute that query it stores 01/01/1999 instead of my pass data. plz give me some suggestion on this.
my query.

insert into voucher(voucherno,name,amount,Voucherdate)
values(" & txtvoucherno.text & ",'" & txtname.text & "'," & txtamount.text & ",'" & format(txtvoucherdate.text,"dd/mm/yyyy") & "')

out put
insert into voucher(voucherno,name,amount,Voucherdate)
values(1,'Andy',5000,'05/04/2004')

though here it show voucherdate '05/04/2004' but it stores in database as 01/01/1999.

 

[bboffin]

Try doing the conversion in SQL instead:

insert into voucher(voucherno,name,amount,Voucherdate)
values(" & txtvoucherno.text & ",'" & txtname.text & "'," & txtamount.text & ",CONVERT(DateTime,'" & txtvoucherdate.text & "',103))

Bob Boffin

 

[donutman]

Even better would be to write a stored procedure and send the parameter data rather than the T-SQL statement.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]