7 Replies Latest reply: Feb 22, 2016 8:20 PM by Christopher Hardy RSS

    How do you create a filter for a date field to bring in items older than today?

    Christopher Hardy

      Trying to pull in data for orders that are past due. I've tried the following filter and it does not appear to work:

       

      OpenOrd Date Dlvry Req<num(today())

       

      FYI I was pulling in invoices with an invoice date of yesterday and it worked with the following value:

       

      =num(today()-1)

       

      Thanks