Google Sheets QUERY returns non-matching records

0
votes

In this workbook 1 the second, "DMK Recent" sheet is populated by a query that returns two records that do not meet the [C > date'2019-12-16'] criterion. These are the last two rows on the sheet. To make things more mysterious, those records display values in the C "Date" field that do not match the source data.

If I reduce the size of the source data, only correctly selected records are returned. Is there some source data size beyond which the QUERY() function loses its grip? Many thanks for any light on this.

1
dategoogle-sheetsgoogle-sheets-formulagoogle-sheets-querygoogle-query-language

1 Answers

1
votes

your query formula:

=QUERY(xFRm!A5:X, 
 "select A,B,C,D,F,E,K,M,G,J 
  where C > date'2019-12-16' 
    and G='THB' 
  order by C,D", 1)

is is working flawlessly.

the culprits in your case are wrongly entered dates

0

go and fix rows 4539 and 4540

0