Support Board

Date/Time: Fri, 27 Sep 2024 07:20:09 +0000

Post From: When comparing a FRACTIME to a TIMEVALUE, the >= operator ignores the =

[2021-08-09 18:17:25] Link To Thread - Link To Post [Go To First Post]
Jeffrey - Posts: 2147
The equal operator (=) by itself is designed to allow some wiggle room if the numbers are slightly off. But the greater or equal operator (>=) enforces that if the left value is even the tiniest bit less than the right, then the operator returns FALSE. That's what's happening in this case. Here are a few alternative formulas you could consider: =K94>=TIMEVALUE("16:59:59.999") =K94>=TIMEVALUE("17:00:00")-1/86400000 =OR(K94>=TIMEVALUE("17:00:00"), ISSAMETIMETOMILLISECOND(K94, TIMEVALUE("17:00:00"))) More generally, only the equal (=) and not-equal (<>) operators have this extra provision to handle numbers that are slightly off. All of the other operators (<, <=, >=, >) are strict in their comparisons. This could potentially be changed if the minor impacts to performance and accuracy are considered worth it.