As far as grouping goes, You can create the first group on DayOfWeek and create a formula for AM/PM and create a second group on that. AM/PM formula If [EMAIL PROTECTED] < 12 Then "AM" Else If [EMAIL PROTECTED] >= 12 Then "PM"
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist Sent: Tuesday, October 28, 2008 9:10 AM To: [email protected] Subject: Crystal Report Question 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" ******* Confidentiality Notice ******* This email, its electronic document attachments, and the contents of its website linkages may contain confidential health information. This information is intended solely for use by the individual or entity to whom it is addressed. If you have received this information in error, please notify the sender immediately and arrange for the prompt destruction of the material and any accompanying attachments. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
