Wildcard in an IN formula

dfloydnike

I tried the below but it is not giving me my 2021 seasons:

[Season] in ('2017FA','2017HO','2018SP','2018SU','2018FA','2018HO','2019SP','2019SU','2019FA','2019HO','2020SP','2020SU','2020FA', '2020HO','2021**') 

I ended up using a starts with: 

[12:11 PM] Floyd, David

startswith([Season], '2021') or startswith([Season], '2021') or startswith([Season], '2020') or startswith([Season], '2019') or startswith([Season], '2018') or startswith([Season], '2017')

BUT I would think there would be a way to say find all seasons that begin with a string.

Blake

Hi @dfloydnike - try the attached filter, it should do what you're looking to accomplish if you just want strings that start with "20xx"

dfloyd.yxmd