5 Replies Latest reply on Mar 21, 2016 2:45 AM by Mahfooj Khan

    Return Value Max Date

    Sunil Rai

      Hi all,

       

      I have a string date field. YYYYmmdd. I can change to date if need be

       

      What I need is to create a calculated field that pulls the LATEST date inventory numbers.

       

      I was hoping I can do something like...if Max (date) then Inventory Qty function. So everyweek I refresh my dashboard, itll take the latest week inventory numbers.

       

      Any easy way to do this?

       

      Cheers,

      Sunil