Greetings List!
Nor a Remedy question, but hopefully someone can help me anyway.
I'm trying to write a report to show all records created between Sunday 7pm
through Friday 7am between the hours of 7am and 7pm.
I've tried
Time({Form.Create Date})>Time (18, 59, 59) or
Time({Form.Create Date})<Time (7, 00, 00)) and
DayOfWeek({Form.Create Date})<>7
however, this gives me records created between Friday 7pm and Sunday 7am as
well, which need to be excluded.
I tried thinking of a way to exclude Sunday AM and Friday PM, but couldn't
think how to do this.
Ideally, I'd like to also group them by Sunday PM/Monday AM, Monday
PM/TuesdayAM, etc.
Does anyone have any ideas?
HUGE THX IN ADVANCE!!!
Shawn Stonequist
EMNS Inc.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
