Support Board
Date/Time: Sat, 23 Nov 2024 15:51:28 +0000
Post From: When comparing a FRACTIME to a TIMEVALUE, the >= operator ignores the =
| [2021-08-09 16:43:27] |
| Sawtooth - Posts: 4118 |
|
There probably is just is a very small a difference related to floating-point error, resulting in this.
If that were the case, then why does the = operator by itself return TRUE?:[ = ] K67=TIMEVALUE("17:00:00") = 1 (number, integer) [ K67 ] K67 = 0.7083333333333333 (number, double) [ TIMEVALUE ] TIMEVALUE("17:00:00") = 0.7083333333333334 (number, double) [ "17:00:00" ] "17:00:00" = "17:00:00" (text) |