Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Fri, 27 Sep 2024 07:13:53 +0000

How to Post a Message for Support

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

[2021-08-09 16:43:27]
[Go To First Post]
Sawtooth - Posts: 4092
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)