<@U7A0KGURX> Ok, I sort of understand. If it helps...
# suitescript
c
@alien4u Ok, I sort of understand. If it helps this is what the filter line is:
Copy code
columns: [
          {
            name: "trandate"
          },
          {
            name: "closedate",
            function: "ageInDays", // this funcition gives a numeric result (as in 5) instead of a MM/DD/YYYY
            sort: nss.Sort.DESC
          },
          {
            name: "tranid"
          },
          {
            name: "entity"
          }
        ],
        filters: [
          {
            name: "mainline",
            operator: "is",
            values: ["T"]
          },
          {
            name: "type",
            operator: "anyof",
            values: ["SalesOrd"]
          },
          {
            name: "trandate",
            operator: "on",
            values: [the_date]
          },
          {
            name: "closedate",
            operator: ["LESSTHANOREQUALTO", "3"]
          },
          {
            name: "trackingnumber",
            operator: "isnotempty"
          }
        ]