Set Expression Not Working Start Date and End Date

[P_Kale]

Hi,

I have created 2 variables to figure out last month start date and End Date. Both this variables are working fine at script level but in Expression these variables are not working. Though expression is not throwing syntax error at front end I am not getting any value. Below given is the expression. I have attached screen-shot as well.

Sum({<PAYOUT_DATE={'>=$(vStartDate)<=$(vEndDate)'},CONSIDER_NOT_CONSIDER={"CONSIDER"}>} PAYOUT_AMT)/10000000

Can you pl help to resolve issue.

Thanks in advance.

@sunny_talwar 

@Anil_Babu_Samineni 

@swuehl 

[P_Kale · Accepted solution]

Hi,

Double quotes resolved the issue for me

Sum({<PAYOUT_DATE={">=$(vStartDate)<=$(vEndDate)"},CONSIDER_NOT_CONSIDER={"CONSIDER"}>} PAYOUT_AMT)/10000000

Thanks

[marcus_sommer · Accepted solution]

The syntax isn't quite right - try it in this way:

... PAYOUT_DATE={">='$(vStartDate)'<=$(vEndDate)'"},CONSIDER_NOT_CONSIDER={'CONSIDER'} ...

Further the date-format from the field and the variables must be equally.

[P_Kale]

Thanks Marcus_sommer,

Got it.