I have a database of items with ‘in season’ start and end dates. Naturally as dates go, these are in mm/dd/yyyy format, although technically these dates are reoccuring each year, so the year is just a placeholder really.
I then have a page with a repeating group, designed to dynamically show all items that are currently in season. I do this by filtering by items where the start date (ignoring year) is in the past, and the end date (ignoring year) is in the future.
The issue is, I have an item which is in season all year round excluding the height of summer. I put the range as july 1 to June 1, but it doesn’t show up in the RG and I can’t figure out how to make that work. I guess it’s something to do with wraparound dates, but I might be too frazzled to figure it out.
The other piece of important information is that I have it structured as two dates vs a range or anything else, because I have functionality to quick add a sighting of that thing, which will then extend the harvest start or end date accordingly via a back end workflow. So I want to keep the date fields as they are. I just need to figure out how to then make sure all items in season in the current month show up in this RG.
I’ve considered doing a separate field that lists out all the months between the two dates, and then using that for the filter, but I have no idea how to actually make this happen.
Yall will be a lifesaver if you can help with this, I’ve thought myself into a puddle over it.
