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?

    shawnmberkeley

      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.