I’m running into an issue connecting the recurring-date and work_hours fields for my use case. My platform manages hundreds of local specials and deals, each with different schedules. Some repeat weekly, others monthly, and some are one-time offers.

The work_hours field works great for recurring weekly hours (like happy hour Mon–Fri 3–6 PM) but can’t handle variable date ranges. The recurring-date field handles flexible or one-time dates perfectly — but it doesn’t support time-based filters like “Open Now” or “Happening at 5 PM.”

My goal is to let users filter deals based on timeframes (e.g., “what’s happening now,” “Friday at 9 PM,” or “next Tuesday”). I tried syncing recurring-date → work_hours via PHP, but the results are inconsistent since each field uses different logic (weekly vs calendar).

Is there any way to make recurring-date work for time filtering or unify the two?