Support Board
Date/Time: Sat, 23 Nov 2024 16:22:52 +0000
Post From: When comparing a FRACTIME to a TIMEVALUE, the >= operator ignores the =
| [2021-08-09 18:17:25] |
| Jeffrey - Posts: 2179 |
|
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. |