一个怪问题请教~~~
Dim Button As Integer
Button = MsgBox("您确定要保存吗?[Y/N]", 36, "提示:")
If Button = 6 Then
Sql = "insert into 生产指示表(shengchanzhishibianhao,bomcode,shengchanzhishiliang,shengchankaishiri,shengchanjieshuri,fuzeren,beizhu) values('" & SCZS_Code & "','" & BOM_Code & "'," & Val(ShuLiang) & "," & Date_Start & "," & Date_Finish & ",'" & FuZeRen & "','" & BeiZhu & "')"
Set conn = New ADODB.Connection
conn.Open ConnectString
MsgBox Sql
conn.Execute Sql
conn.Close
Adodc1.Refresh
Text_Fettle
End If
Date_Start和Date_Finish 都是日期控件,我的数据库的列也为日期型的,结果我明明是选的是今天的日期,存入数据库里面就成了 1905-6-6 了~这是怎么回事?怎样解决呢?
请求帮助~