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 example, I'm now storing startdate and enddate. Saythe event
runs from yesterday until tomorrow. When querying for today, neither date is
within the parameter. My current solution is something like this:
where startdate = #thisdate# OR enddate = #thisdate# OR (startdate <
#thisdate# and enddate > #thisdate#)
Any suggestions on displaying records within a date range?
Thanks
Michael
Won't worry, be happy!
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
--
Donna M. Martin
Applications Dev/Analyst, Sr
Pathology Dept, Emory University
404 727-5918 Phone
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
