Miki, ne moze ovako!!!
Code:
SQL = "SELECT * FROM ulaz WHERE ""datum>=" & Format(DTPicker1.Value, "Medium Date") & " and datum<='" & Format(DTPicker2.Value, "Medium Date") & "'"
Ili namesti datum na US format i datume razdvajaj tarabama (#) , ili koristi ovo moje resenje sa : DataEnvironment1
Code:
DataEnvironment1.rstablica.Open "Select * From tablica order by ID DESC"
DataEnvironment1.rstablica.Filter = "datum>=" & Format(DTPicker1.Value, "Medium Date") & " and datum<='" & Format(DTPicker2.Value, "Medium Date") & "'"
CP podesavanja:
Datum : dd.mm.yyyy
Jezik: Serbian ( Latin )
Nazive meseci dobijas onako kako si trazio: Januar, Februar...
Polje datum u tabeli TABLICA nije text nego Date/Time
[Ovu poruku je menjao loto17 dana 11.04.2013. u 15:54 GMT+1]