5 Replies Latest reply: Feb 12, 2014 8:39 AM by Ville Syrjänen RSS

    Max date from sales data

      Hi all,


      I would like to show last date with sales on report in a Text box. What would be the expression? I have tried several, but non of them work.


      This is approximately what I need: Maximum Date from Sales-table where sum of SalesQty is not 0. There are a lot of dates in future without sales and that's why I can't just take max(date) from table.