How to return the latest 10 values (Rows) using query in google sheets?

I've been trying to return the latest 10 dates, but it's bringing wrong data:

=QUERY('DB Queried'!A4:G,"select A order by A Desc Limit 10")

Resulting in:

...where there should be dates in the month of May, for example.

Appreciate your help.

https://stackoverflow.com/questions/67377979/how-to-return-the-latest-10-values-rows-using-query-in-google-sheets May 04, 2021 at 10:21AM