Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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)
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)
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
Thanks it worked. Don't know why but it worked