1 Reply Latest reply on Jan 17, 2014 12:38 PM by philmodjunk

    Can I Search for the Latest Date in a field

    dansan500

      Title

      Can I Search for the Latest Date in a field

      Post

           I need to create an aging Inventory report

           Inventory - I need to search for an Item#, that has Qty on hand: (This is the part I don't know how to do) in the date field, I need to search for the last date entered, or newest Date..

           When Inventory comes in it is entered by date

           When I do a search for inventory on hand that was entered in 2009 it reports it, the problem is that if items were enter after that and is included in the inventory total it doesn't show that.