7 Replies Latest reply: Feb 13, 2013 4:23 AM by Hennie Welman RSS

    Get last date for which has a value

    Hennie Welman

      Hi,

       

      I have the following table:

       

       

      DateProduction (meters)
      01/02/2013108
      02/02/2013502
      03/02/2013300
      04/02/20130
      05/02/20130

       

      I want to get the last date which has got a Production value (so it will be 03/02/2013 because the dates thereafter has not values). The date must be able to show in a text box.

       

      How can I do it using a formula/expression?

       

      Thank you in advance