This is how I attacked the problem.
I created two formulas.
* DayOfWeek
o DayOfWeek ({HPD_HelpDesk.Create Time})
* Hour
o Hour ({HPD_HelpDesk.Create Time})
I then used them in the Select Statement.
{HPD_HelpDesk.Create Time} in LastFullWeek and
(([EMAIL PROTECTED] = 1 AND [EMAIL PROTECTED] > 19) OR
([EMAIL PROTECTED] = 2) OR
([EMAIL PROTECTED] = 3) OR
([EMAIL PROTECTED] = 4) OR
([EMAIL PROTECTED] = 5) OR
([EMAIL PROTECTED] = 6 AND [EMAIL PROTECTED] < 19))
-----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"
