Set analysis and date

[delbooth]

Hi.

i am using the below as part of a set analysis expression.

num(EntMonth) =month(Today())

  The Entmonth is Jan to Dec field but I want to evaluate it as a number in order to be able to get a graph for the last three months of data by using month(today())-1,and month(today())-2

The set analysis does not seem to work

Thanks

Del

[arulsettu]

try in set

num(EntMonth) ={num(month(Today()))}

[YoussefBelloum]

Hi,

you can rollback on months using the original format of the field, using something like this:

EntMonth={'$(=Date(Date#(month(Today())-1,'MM'),'MMM)'}

[rwunderlich]

Please post your entire expression. Your syntax looks incorrect.

-Rob