How can I omit records from "non current year".
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.