Have you tried using thisdate between startdate and enddate?
Donna
Quoting "Singles Concepts, Inc." <[EMAIL PROTECTED]>:
Hey Group Members,
I hope this question finds you in good spirits this evening.
I'm having trouble creating an elegant calendar query to handle multi-day
events. For examp
Hey Group Members,
I hope this question finds you in good spirits this evening.
I'm having trouble creating an elegant calendar query to handle multi-day
events. For example, I'm now storing startdate and enddate. Saythe event
runs from yesterday until tomorrow. When querying for today, neither d