Hi Shawn,
A rather easier way of doing this would be to use "Select Expert". Your
records probably need grouping via Day/Date. Once the records are grouped
you can use select expert to define the criteria for your report. Please
consider the following formula as an example.
[EMAIL PROTECTED] in Time (0, 00, 40) to Time (0, 20, 40) and
{Form.Date/Time} in DateTime (2008, 08, 13, 00, 06, 40) to DateTime (2008,
09, 07, 12, 32, 01)
In the above formula "@Time" is a variable that I created which basically
returns Time from "DateTime" field.
Hope this approach would help you.
Regards,
Mohtashim Abbasi
Remedy Consultant
Technosys UK Limited
DDI : +44208 429 5954
Main: +44208 429 5955
Mobile: +447590554781
Email: [EMAIL PROTECTED]
Web: http://www.technosysuk.com
204 - 226 Imperial Drive
Rayners Lane, Harrow
Middlesex HA2 7HH
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist
Sent: 28 October 2008 14:10
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"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
