LiveCloud arrays and Datagrid

[sid]

Hi Efrain

I ran the query successfully and it returned a response, but here's the thing

It returned records from the 10th december to the 13th december into the datagrid, not from the 1st december to the 13th.

Basically the query is to search the records from the 1st to 13th December

so I tried putting in the following -convert- code to covert the variable into a date

put text of field "dateFromField" into tToDate
  convert tToDate to short date
  put text of field "dateToField" into tFromDate
  convert tFromDate to short date
 
  put cdb_TableID("logs") into tTableID
  put cdb_tableKeys("logs") into tKeys
 
 
  put "date" into tInputA[tTableID]["query2"]["key"]
  put "<=" into tInputA[tTableID]["query2"]["operator"]
  put tFromDate into tInputA[tTableID]["query2"]["value"]
  put "date" into tInputA[tTableID]["query1"]["key"]
  put ">=" into tInputA[tTableID]["query1"]["operator"]
  put tToDate into tInputA[tTableID]["query1"]["value"]

etc etc


and I ran it again, but it still left out records on the 1st, 3rd, 6th etc

here's a sample of the database records can be downloaded with this link:

https://www.dropbox.com/s/6wtjs8bsbvevg2...0.csv?dl=0

Thanks again for the help