4 Replies Latest reply on Mar 24, 2017 2:33 PM by shawnmberkeley

    How to script a find for records with a range between two calculated date fields?


      I am attempting to write a script to find only records that have three days or fewer between two calculated date fields.


      job::DateDelivery_Scheduled - job::DateToVendor_Scheduled ≤ 3


      It might not matter for the find script, but the date fields are calculated as follows:


      Case (

      not IsEmpty (DateDelivery_Revised ) ; DateDelivery_Revised ;

      DateDelivery_Original )


      Case (

      not IsEmpty (DateToVendor_Revised ) ; DateToVendor_Revised ;

      DateToVendor_Original )


      I just cannot seem to make the find work.  Any help would be appreciated.