[Qgis-user] Query Builder - I thought I understood what I was doing.

[oisin.kelly.wild at gmail.com]

ClIf its a string can use slice, e.g.
"DateSale"[7:10] to return YYYY


⁣O

Get BlueMail for Android ​

On 12 Jun 2024, 19:40, at 19:40, Jeremy Swarm via QGIS-User <qgis-user at lists.osgeo.org> wrote:
>I have a set of vectors (it's a parcel map) from my county. This layer
>has a number of attributes defined. I would like to filter the features
>by an attribute called "DateSale". it is formatted MM/DD/YYYY. I
>believe it is astring. I would like to find features which end with any
>of 2021,2022,2023, ,or 2024. I have not been able to build a successful
>filter with the query builder.
>
>------------------------------------------------------------------------
>
>_______________________________________________
>QGIS-User mailing list
>QGIS-User at lists.osgeo.org
>List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20240612/d591df2f/attachment.htm>