How can I make this hour comparison?

rcandeo — Mon, 09 Sep 2013 19:04:38 GMT

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:

Re: How can I make this hour comparison?

Anonymous — Mon, 09 Sep 2013 19:10:14 GMT

Hi,

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

Regards

Ashok.

rcandeo — Mon, 09 Sep 2013 19:15:37 GMT

worked using num# function:

num#(CallHour ) > num#(vFinalHour)

Thank You