[Programmer-VB] Mohon Pencerahan SQL Statement lagi

[McBoenBoen]

Dear Pakar VB,
   
  mohon pencerahan kenapa stement SQL ini eror?
   
  cn.Execute "INSERT INTO 
temporary_tbl(nopp,attendance_id,day_shift,attendance_time,attd_info,dd_day)" & 
_
           "SELECT nopp,attendance_id,day_shift, attendance_time, 
attd_info,dd_day FROM attendance_trx" & _
           "WHERE (convert(varchar, attendance_time, 103))=cast('" & 
DTPicker1.Value & "' as datetime)" & _
           "ORDER By attendance_id, npp, attendance_id "

  eror terjadi pada Convert
   
  NOTE : type filed attendance_time adalah DateTime isinya "28/08/2007 10:25:11 
AM"
   
  atas bantuan teman2 sebelumnya byk terimkasih.
   
  salam,
  mc
   

       
---------------------------------
Need a vacation? Get great deals to amazing places on Yahoo! Travel.