using Time In Crystal reports

To get it in minutes use

DateDiff ('n',CDateTime(Today,{?My Parameter}), CDateTime(Today, {?My Parameter 2}))

n - minutes
h - hours
s - seconds

specifically, the date range in that field is between 7:00:00 pm and 12:00:00 AM

The range doesn't matter unless it crosses midnight
Assuming you have START TIME and END TIME parameters and the user enters them that way

This should work

Local TimeVar StopTime := {?End Time};

If StopTime = Time(0,0,0) then
    StopTime := Time(23, 59, 59);

DateDiff ('n',CDateTime(Today, {?Start Time}), CDateTime(Today, StopTime))

Select allOpen in new window

Another way

Local TimeVar StopTime := {?End Time};

If StopTime = Time(0,0,0) then
    DateDiff ('n',CDateTime(Today, {?Start Time}), CDateTime(Today+1, StopTime))
Else
    DateDiff ('n',CDateTime(Today, {?Start Time}), CDateTime(Today, StopTime))

Select allOpen in new window

mlmcc

since I'm going to place this in the Report... record like where clause in a SQL statement..
what I'm asking is something like express in Sql but in this case in Crystal.

so in short please translate this in crystal

where Enttime between 7:00 pm and 12:00 pm...

Thanks for showing ways to do it