topic Re: Set Expression Not Working Start Date and End Date in App Development

Set Expression Not Working Start Date and End Date

P_Kale — Mon, 08 Jan 2024 12:43:04 GMT

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

Re: Set Expression Not Working Start Date and End Date

P_Kale — Mon, 08 Jan 2024 13:52:45 GMT

Hi,

Double quotes resolved the issue for me

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

Thanks

Re: Set Expression Not Working Start Date and End Date

marcus_sommer — Mon, 08 Jan 2024 13:58:00 GMT

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.

Re: Set Expression Not Working Start Date and End Date

P_Kale — Mon, 08 Jan 2024 14:16:56 GMT

Thanks Marcus_sommer,

Got it.