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

[oisin.kelly.wild at gmail.com]

Sorry, slice doesn't work on expressions. Use

substring("DateSale", 7, 10)

⁣Oisin
07570 977449

Get BlueMail for Android ​

On 12 Jun 2024, 19:59, at 19:59, "oisin.kelly.wild at gmail.com" <oisin.kelly.wild at gmail.com> wrote:
>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/2c32cfb0/attachment.htm>