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.w...@gmail.com"
<oisin.kelly.w...@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@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@lists.osgeo.org
>>List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
