7 Replies Latest reply: Dec 2, 2016 5:17 AM by Sunny Talwar RSS

    Date functions in set expression

    Mikko Sippola

      Hi, I want to have a table which constantly shows recent sales, regardless of current selection. Currently I'm a bit lost at why these two below don't yield same results?

       

      Sum(If(date > '2016-08-08', sales))                         works fine

       

      Sum({$< date = {"> '2016-08-08'"}>} sales)               gives zero as the result

       

      And next question would be how to use functions in set expression. Ideally I'd want to have something like

       

      Sum({1< date = {"> Date(Interval(Today() - 7, 'D'))"}>} sales)               but that gives zero as well.