[Qgis-user] filter by date field

[Matt Boyd]

Hi QGISers
I'm trying to filter some data by date.
The field is classified as date data (it's a shapefile) and it's formatted
yyyy/mm/dd

If create a filter

"datafield" < '2000/01/01' I get a type mismatch error,

Same error using BETWEEN

I can get it to work if I export as csv and change 2000/01/01 to 2000-01-01
then use a join on the ID, then save that as a new shapefile and then
filter by the 2000-01-01 field

I'm assuming that a / isn't an acceptable date delimiter. Does anyone know
if this is expected behavior and if I can do something to avoid this step?

Thanks
matt
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20170327/2b5aac3a/attachment.html>