取日期时候出错,急!!!
Form里面有四个text,分别是txtyear1,txtmonth1,txtyear2,txtmonth2,txtday2,表中有字段date1,date2,想把Form里显示的内容放入表中,怎么样获到呢?
date字段是datetime型数据,而txtyear1是096,txtmonth1是07
date1里面显示09607,,date2里显示0960602.
急,在线等,谢谢

[解决办法]
那表中date1和date2都必须是varchar类型，不可以用datetime类型

try:

dim date1 as string
date1 = txtyear1.Text & txtmonth1.Text
strsql = "select last_date,last_person from Selfaudit where Verification_date= ' "& Trim(date1) & " ' "



[解决办法]
dim date1 as string
date1 = txtyear1.Text & txtmonth1.Text
strsql = "select last_date,last_person from Selfaudit where Verification_date= ' "& Trim(date1) & " ' "