Database Error WHERE Clause

[ken gray]

Thanks.
What about the SQL language it uses?  I've tried T-Sql and Sqlite for casting a string as a datetime but can't seem to make it work.
Any thoughts on what I'm doing wrong here?

Macro Macro7

Code:

Copy      Help

out
str s =
;Date,Rep,Total
;7/19/2022 7:48:34 AM,10,600
;7/19/2022 8:18:56 AM,10,600
;7/19/2022 8:39:38 AM,20,600
s.setfile("C:\Temp\move2.csv")

Database dbt.Open(dbt.CsText("C:\Temp"))
ARRAY(str) at
dbt.QueryArr("SELECT cast(date as date) FROM move2.csv where rep=20" at)
out  at