2 Replies Latest reply on Sep 29, 2015 1:52 PM by erolst

    Perform Find: Less than column value

    rustyshackleford

      I'm trying to "perform find[]" with the follwing in the field: ≤rel_TimeSlips_Globals_Prebill_Filter_to_MASTER_Slip_Entries__MAIN::ts_PreBillFilter_Date_End, but it won't let me use less-than or equal to with a column name. Is there a way to perform a find in a script with the field set as less than or equal to a field's amount?3.PNG

        • 1. Re: Perform Find: Less than column value
          erolst

          Heed the alert – and use:

           

          "<=" & rel_TimeSlips_Globals_Prebill_Filter_to_MASTER_Slip_Entries__MAIN::ts_PreBillFilter_Date_End

           

          While you can enter ≤someValue manually in Find mode, in the calculation engine that is an invalid expression; so you need to pass the operator as a string. Compare with

           

          SomeTable::gDateBegin & ".." & SomeTable::gDateEnd

          • 2. Re: Perform Find: Less than column value
            erolst

            To be clear: the chosen variant of the less-than-equal operator wasn't the issue here; you can of course use

             

            "" & rel_TimeSlips_Globals_Prebill_Filter_to_MASTER_Slip_Entries__MAIN::ts_PreBillFilter_Date_End

             

            I just happen to like to visual appearance of =< and >= – not to mention <=> …

            1 of 1 people found this helpful