I'm stuck for days, please help me. I have an event calendar and i need to compare in the form, whether the given location (column [Venue]) is free at the selected time ([EventStartDate] and [EventEndDate] - both are DateTime column) of a planned event. Every datas are on the same table (EVENTS). The compare of the date range works fine, but i cannot compare properly the [Venue] column, wich type is EnumList.
I have tried a lot of expression, nothing is work properly yet. With the last expression, it seems to me, that it compares just the first element of the list, than stops. So other items are left out of the list.
This is the closest i've been:
User | Count |
---|---|
35 | |
11 | |
3 | |
3 | |
2 |