Filtering Dates

[Himaladin]

How can I check if a date is included in an array of dates?

[Darren_Murphy]

Contains and Does not contain both work with arrays.

[Himaladin]

I couldn’t find ‘contain or doesn’t contain’ in the filter settings.

[Darren_Murphy]

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?

[Himaladin]

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.

[Darren_Murphy]

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.

[Himaladin]

Oops, my mistake. Thank you for pointing that out.