<html><head></head><body style="zoom: 0%;"><div dir="auto">Sorry, slice doesn't work on expressions. Use<br><br></div>
<div dir="auto">substring("DateSale", 7, 10)<br><br></div>
<div dir="auto"><!-- tmjah_g_1299s -->Oisin<!-- tmjah_g_1299e --><br></div>
<div dir="auto"><!-- tmjah_g_1299s -->07570 977449<!-- tmjah_g_1299e --><br><br></div>
<div dir="auto"><!-- tmjah_g_1299s -->Get BlueMail for Android <!-- tmjah_g_1299e --></div>
<div class="gmail_quote" >On 12 Jun 2024, at 19:59, "oisin.kelly.wild@gmail.com" <<a href="mailto:oisin.kelly.wild@gmail.com" target="_blank">oisin.kelly.wild@gmail.com</a>> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div dir="auto">
ClIf its a string can use slice, e.g.
<br>
</div>
<div dir="auto">
"DateSale"[7:10] to return YYYY
<br>
<br>
<br>
</div>
<div dir="auto">
<!-- tmjah_g_1299s -->O<!-- tmjah_g_1299e -->
<br>
<br>
</div>
<div dir="auto">
<!-- tmjah_g_1299s -->Get BlueMail for Android <!-- tmjah_g_1299e -->
</div>
<div class="gmail_quote">
On 12 Jun 2024, at 19:40, Jeremy Swarm via QGIS-User <<a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a>> wrote:
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div dir="auto">
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.
</div>
<pre class="blue"><hr><br>QGIS-User mailing list<br>QGIS-User@lists.osgeo.org<br>List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br></pre>
</blockquote>
</div></blockquote></div></body></html>