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

    Count current month

    Joanna Seldon



      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