Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try in set
num(EntMonth) ={num(month(Today()))}
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)'}
Please post your entire expression. Your syntax looks incorrect.
-Rob