5 Replies Latest reply: Feb 23, 2015 3:01 AM by ar eiuiew RSS

    Comparing dates in set analysis

    ar eiuiew

      my Expression looks like this :

       

      avg({<PurchaseDate<=2015-01-15>}Sales

       

      as you can see I have a Date column (PurchaseDate) and a simple date 2015-01-15

      in sql i would simply :

      PurchaseDate <= convert(datetime,'2015-01-15',suitable Style)

       

      thanks in advance