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)