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

[chris hermansen]

Jeremy, list;

On Wed, Jun 12, 2024 at 11:40 AM 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.
>
> You don't say why you "believe" it is a string.  You can check the field
types...

Anyway, in case it's a date, you can use the year function in the query
builder e.g. year(DateSale)

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20240612/9ade28d6/attachment.htm>