Yea, querying like that does work. Should have thought of that, since I have queried successfully on _kmd.* in other scenarios.
I didn't write the code to add or update the data, i've just been querying it - I guess it's possible that the way it was coded it is setting the date columns incorrectly? Behind the scenes, is "_kmd.lmt" an ISODate, but the Kinvey console just shows it as a simple date for ease of interaction?
over 8 years ago
`_kmd` date values are stored as strings in the database (they are native Date objects that have been converted to string). If you need to store your dates as ISODates, then you will need to use the wrapper to search, as you've discovered.
I tried using the raw date in the form:
And wasn't successful. Strangely, I got back everything in this case totally unfiltered. If I made it "$lte", it returned nothing.
However, when I change my format to accurately match that of the collection, the queries started working.
Now I can run "$gte" and "$lte" queries without an problems, and they appropriately filter.
Am I doing something wrong, or is it that I actually should be querying them this way?