--- In [email protected], McBoenBoen <[EMAIL PROTECTED]> wrote: > > Dear All, > > mohon pencerahan, bagaimana caranya update field Flag dengan membandingkan field tgl_expire dengan tanggal inputan. saya coba tapi masih error... > berikut scripnya.. > > > cn.Execute "update tbl_perdana set flag='Expire' where tgl_expire < '" & DTPicker1.Value & "'" > > > tgl_expire=date/time > database=Access 2003 > > > terimakasih atas pencerahannya > > salam, > mc > > > > --------------------------------- > Got a little couch potato? > Check out fun summer activities for kids. > > [Non-text portions of this message have been removed] > coba dirubah tanda kutip tunggal (') mejadi tanda pagar(#) untuk access, dan tanggal harus dalam format US.
cn.Execute "update tbl_perdana set flag='Expire' where tgl_expire < #" & Format(DTPicker1.Value, "mm/dd/yyyy") & "#" Hendra Software Engineer PT. Halotec Indonesia Tel/Fax: 061 4514963 HP: 085270589175 Call now for all your software needs!
