2 Replies Latest reply: Oct 13, 2015 9:09 AM by Joanna Seldon RSS

    Count current month

    Joanna Seldon

      Hiya

       

      in my sql data load I have Order_Date in the following format

       

      20140101 00:00:00

       

      this contains data for 3 years.

       

      I have in my data load done this

       

      Month(Order_Date) as Month

       

      my expression is

       

      count({$< Month ={$(=Month(today()))}  >}Customer_ID)

       

      but it is counting every order date month that contains October, I just want count for Oct 2015

       

      if I do this

       

      count({$< Month ={$(=MonthStart(today()))}  >}Customer_ID)

       

      I get -

       

      Please Help