Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this
=if( interval(sqlTimeArray,'hh')<= interval(time#(strTime,'hh:mm:ss'),'hh'),1,0)
what is format of sqlTimeArray & StrTime?
sqlTimeArray has time values, for example: 12:26:30
StrTime I formated has "time", so also in the same format, ex: 14:08:05
HI,
Try like this
hour(Date(Date#(time_string,'hh:mm:ss'),'hh:mm:ss'))
Hi,
Try Like
=if(hour(sqlTimeArray)<=hour(strTime),1,0)
or
if(Interval('sqlTimeArray','HH')<Interval('strTime','HH'),1,0)
try this
=if( interval(sqlTimeArray,'hh')<= interval(time#(strTime,'hh:mm:ss'),'hh'),1,0)
Apparently with this solution it works.
Thank you.
I am glad that it was helpful