Compare time with string

[#1]

Hello,

I make a sql query that gets an array of time values and I want to show only the values that are bigger than a specific value that I save on a string.

The value I save to a string it is another time value saved on my script.

The condition I have is:

=if(hour(sqlTimeArray)<=strTime,1,0)

But this condition does not work and shows all the values I have on the array.

Am I doing something wrong?

Thanks in advance.

Regards,

Ivo

[Kushal_Chawda]

what is format of sqlTimeArray & StrTime?

[#3]

sqlTimeArray has time values, for example: 12:26:30

StrTime I formated has "time", so also in the same format, ex: 14:08:05

[sasikanth]

HI,

Try like this

hour(Date(Date#(time_string,'hh:mm:ss'),'hh:mm:ss'))

[settu_periasamy]

Hi,

Try Like

=if(hour(sqlTimeArray)<=hour(strTime),1,0)

or

if(Interval('sqlTimeArray','HH')<Interval('strTime','HH'),1,0)

[Kushal_Chawda · Accepted solution]

try this

=if( interval(sqlTimeArray,'hh')<= interval(time#(strTime,'hh:mm:ss'),'hh'),1,0)

[#7]

Apparently with this solution it works.

Thank you.

[Kushal_Chawda]

I am glad that it was helpful