Print Page | Close Window

Remove records outside time range

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14297
Printed Date: 03 May 2024 at 1:32pm


Topic: Remove records outside time range
Posted By: Dgtldrgn
Subject: Remove records outside time range
Date Posted: 08 Sep 2011 at 5:57am
I am working with Crystal 10 and trying to create a report that shows tickets created between the hours 8am and 4pm. I created a field that seperates the time from a datetime field, and used the following to supress the records before 8am (Except 1am still shows up), but I cant get the after 4pm tickets to disappear. Please help.
 
@Worktime is the formula that seperates the time from the datetime field and shows the time in my report.
 
mailto:%7b@WorkTime - {@WorkTime } IN Time (00, 00, 00) To Time (07, 59, 59)
 


Replies:
Posted By: hilfy
Date Posted: 08 Sep 2011 at 7:22am

The formula above shows records between midnight and 7:59:59 am.  If you want the records between 8 am and 4 pm, I would try this:

mailto:%7b@WorkTime - {@WorkTime } in Time(08, 00, 00) to Time(15, 59,59)
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window