Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Remove records outside time range Post Reply Post New Topic
Author Message
Dgtldrgn
Newbie
Newbie


Joined: 08 Sep 2011
Location: United States
Online Status: Offline
Posts: 1
Quote Dgtldrgn Replybullet Topic: Remove records outside time range
    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.
 
{@WorkTime} IN Time (00, 00, 00) To Time (07, 59, 59)
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet 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:

{@WorkTime} in Time(08, 00, 00) to Time(15, 59,59)
 
-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.