How to write set analysis for taking monthly data?

[#1]

Hi experts,

                  I want to take a data from 1st of this month till today...How can I write set analysis on tran_date??

   I write this one but it is not working...

       tran_date={'>=$(=floor(monthstart(max(tran_date))))'}

[settu_periasamy]

Hi,

is that giving the number format? , then try like

  tran_date={'>=$(=monthstart(floor(max(tran_date))))'}

[jonathandienst]

Hard to say without more understanding of your model and how its being used . The set expression looks OK, so you need to explain what is not working. An uploaded example qvw is the best. I would simplify the expression a little, like this:

    tran_date={">=$(=monthstart(max(tran_date)))"}

But is the user selecting tran_date, or are they selecting other calendar fields like month, year etc? You might need to override these, like

    tran_date={">=$(=monthstart(max(tran_date)))"}, Year=, Month=

[#4]

Hi jonathan,

I am calculating good recieving note(GRN) bill amount for this month till today...I wrote this-

sum

  (

  {<

  tran_date={'>=$(=monthstart(floor(max(tran_date))))'}

  >}

  stock_tran_in_prod_value      // it is amount for one bill

  )