Set Analysis with Variables

[#1]

I am trying to convert this expression into set analysis.

here vFromDate and vToDate are variables

Can anyone help me in forming the expression for the same in set analysis

[kaushiknsolanki]

Hi,

     Try this.

     Count({<ACTIVE = {"1"},GOAL_CREATED_DT = {">=$(vFromDate)<=$(vToDate)"}>}GOAL_MEM_RMK)

Regards,

Kaushik Solanki

[MayilVahanan]

Hi

Try like this

Count({<ACTIVE = {"1"},GOAL_CREATED_DT = {">=$(Date(vFromDate))<=$(Date(vToDate))"}>}GOAL_MEM_RMK)