Time Range Problem with Formula

[Gizmo0917]

if time({table.field}) >= time(7,30,0)
and
time({table.field}) < time(19,0,0) then
"Shift 1"
else
"Shift 2"


I am getting an error that says a ) is missing. I have double checked and can not find where to put the paren. Any suggestions?

Thank you,

 

[dgillz]

Gizmo,

Keep it to one thread, if you please. See the other thread for my answer.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com