getResource Filter on two date TVs

I've got resources with two different TVs: event-date and event-end-date. Single day events use only the event-date TV, while multi-day events use both fields.

I've been using this to filter for future dates.

This works, however, the multi-day events drop off the list before the end date.

So I tried adding an OR filter like this:

This produces the same result as the previous filter.

As test, I tried filtering on the event-end-date just to confirm the field was valid.

This produced a list of only those events with a value in event-end-date.

PS. I tried use @where with no luck. I got either all resources or none. Not sure if this even works with TVs.

So why doesn't this work?

I don't see any reason why that wouldn't work, but if you give the one-day events an end date (the same as the event-date), you could try this (untested):

Hey Bob, thanks

I was hoping to avoid that because of the number of events that would have to be edited, multi-day events are the exception, and since the client is adding events, it's likely they will forget to include this on every entry.

Perhaps tomorrow a fresh set of eyes will help.

A utility snippet could set the end dates on the existing single-day events, but you might try the technique on a few to see if it works.

When you look in the DB, are the dates set as human-readable strings or just a big number (unix timestamp)?

Do you need getResources? A custom snippet could pull out those resources and use the same tpl Chunk to display them.