[alfaiz678]

اترك between
وجرب هذه

كود :

       rs.Open " Select * From table_name where date >= '" & Format(date1, "yyyy/MM/dd") & "' and date<='" & Format(date2, "yyyy/MM/dd") & "'", db, adOpenKeyset, adLockPessimistic

[walkady]

(14-12-19, 08:44 AM)alfaiz678 كتب : اترك between
وجرب هذه

كود :

       rs.Open " Select * From table_name where date >= '" & Format(date1, "yyyy/MM/dd") & "' and date<='" & Format(date2, "yyyy/MM/dd") & "'", db, adOpenKeyset, adLockPessimistic

rs.Open " Select * From table_name where date >= 'N" & Format(date1, "yyyy/MM/dd") & "' and date<=N'" & Format(date2, "yyyy/MM/dd") & "'", db, adOpenKeyset, adLockPessimistic

لاحظ يجب اضافة حرف N