Date Range in Set Expressions

[#1]

I have a variable defined

SET vPE_date = date#('31/Oct/2013');

Now I am trying to use it in set expression and I am trying as follows:

Sum({$<ISSUEDT= {'<= $(vPE_date)'}>} NET_CLAIM_PAID)

However this is not working.

Can someone guide me why.

Thanks.

[MK_QSL · Accepted solution]

Try to Define Your variable as below

Let vPE_date = Date(Date#('31/Oct/2013','DD/MMM/YYYY'));

Use

Sum({$<ISSUEDT= {"<=$(=vPE_date)"}>} NET_CLAIM_PAID)

[its_anandrjs]

You have to make change in script it is not SET it would be LET

LET vPE_date = Date(Date#('31/Oct/2013','DD/MMM/YYYY'),'DD/MM/YYYY');

and in expression

Sum({$<ISSUEDT= {"<= $(vPE_date)"}>} NET_CLAIM_PAID)

[sushil353]

Hi,

Try below:

LET vPE_date = Date(date#('31/Oct/2013').'DD/MMM/YYYY');

Sum({$<ISSUEDT= {"<= $(vPE_date)"}>} NET_CLAIM_PAID)

Make sure that ISSEDT should have DD/MMM/YYYY format.. if not then change the format of variable vPE_date accordingly

HTH

Sushil

[#5]

Thanks it worked. Don't know why but it worked