# Filtering Dates **URL:** \ **Category:** Ask for Help\ **Created:** [December 24, 2023, 1:42am UTC](https://community.glideapps.com/t/filtering-dates/68974 "2023-12-24T01:42:39Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [December 24, 2023, 1:42am UTC](https://community.glideapps.com/t/filtering-dates/68974/1 "2023-12-24T01:42:39Z")
How can I check if a date is included in an array of dates? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 24, 2023, 3:59am UTC](https://community.glideapps.com/t/filtering-dates/68974/2 "2023-12-24T03:59:28Z")
`Contains` and `Does not contain` both work with arrays. ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [December 24, 2023, 4:13am UTC](https://community.glideapps.com/t/filtering-dates/68974/3 "2023-12-24T04:13:52Z")
I couldn’t find ‘contain or doesn’t contain’ in the filter settings. ![Screenshot 2023-12-24 at 11.08.03](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/a/3a3e2e04ffd37778105c197760de1699fab3984e.png) ![Screenshot 2023-12-24 at 11.09.54](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/0/e082191101ba24aaf69cd43fc753c41a55abe1d3.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 24, 2023, 4:31am UTC](https://community.glideapps.com/t/filtering-dates/68974/4 "2023-12-24T04:31:24Z")
How is that Date Range Selection column created? Just as an aside - the name of the column suggests a Start Date and an End Date (ie. a range) rather than an array. What exactly are you trying to do? ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [December 24, 2023, 4:49am UTC](https://community.glideapps.com/t/filtering-dates/68974/5 "2023-12-24T04:49:33Z")
I created the attendance feature within the edit model. The ‘Date Range Selection’ is the result of Usc’s selection of which column needs to be displayed. ![Screenshot 2023-12-24 at 11.39.13](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/c/8ccaf5ecc5432ba34ea7050b3a318a896173f894.png) ![Screenshot 2023-12-24 at 11.44.08](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/c/0c9cecc535df00d5e227d9887141bf9b7ad7dbb2.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 24, 2023, 5:07am UTC](https://community.glideapps.com/t/filtering-dates/68974/6 "2023-12-24T05:07:05Z")
That is not an array, it is a Joined List. To check if something is in a Joined List, use “includes”, “doesn’t include”. You should be careful with this. If all of your dates are not _exactly_ midnight, then you will get unexpected results. ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [December 24, 2023, 5:24am UTC](https://community.glideapps.com/t/filtering-dates/68974/7 "2023-12-24T05:24:32Z")
Oops, my mistake. Thank you for pointing that out. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [January 22, 2024, 5:15pm UTC](https://community.glideapps.com/t/filtering-dates/68974/8 "2024-01-22T17:15:39Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.