10 Replies Latest reply on Sep 11, 2012 1:32 PM by BrianClemens

    How can I omit records from "non current year".

    BrianClemens

      Title

      How can I omit records from "non current year".

      Post

           I have a report that sorts off of sold status based on a script.

           On Order: shipped date blank, returns a 1

           In Inventory: contains ship date, but sold date is blank.  returns a 2

           Sold: sold date contains a value, returns a 3

           What I would like the script to do is constrain the found set of "SOLD" to only include units from the current year.