Expression

[smilingjohn]

Hi All,

Can any one explain me what is the meaning of the below expression. what this expression will ?

count({<Date={">=$(=AddMonths(Today(),-6))<=$(=Today())"}>}DISTINCT Product)

Regards

John

[sunny_talwar · Accepted solution]

This expression means:

Count all distinct products which are available within last 6 months

[alexandros17]

count({<Date={">=$(=AddMonths(Today(),-6))<=$(=Today())"}>}DISTINCT Product)

You count the distinct product with following conditions (Explicited by set analysis)

(A) AddMonths(Today(),-6) is a date starting 6 months before today

the whole condition ">=$(=AddMonths(Today(),-6))<=$(=Today())" says that the field Date must be

>=(A) and <= today

and finally you have to know that if you write (=Expression) the expression is evaluated so in your case

$(=AddMonths(Today(),-6))

computes the function Addmonths

Hope this helps

[hcabrera]

Hi,

This expression does is count the different products dated from 6 months ago ">=$(=AddMonths(Today(),-6) to less equal to today <=$(=Today())"