How can I make this hour comparison?

[rcandeo]

Hi, I have a variable created as this:

vFinalHour = MakeTime(18);

and I have to comparisse if the calls are later than this final hour (18:00:00)

The CallHour field (that is timestamp) is defined as this in the script load:

time(Date_Call,'hh:mm:ss') as CallHour

If I try to make this comparisson:

If(CallHour > vFinalHour,0,vFinalHour - CallHour)

I receive 0, as all my CallHour was bigger than 18:00:00 hs and this is not true, as If I make the calculation only:

vFinalHour - CallHour I have good results, excepting when CallHour > vFinalHour.

Anyone can help me doing the correct comparison please:

[Anonymous]

Hi,

try to use num function like num(CallHour ) > num(vFinalHour)

Regards

Ashok.

[rcandeo · Accepted solution]

worked using num# function:

num#(CallHour ) > num#(vFinalHour)

Thank You