topic Calendar Picker sets variable as date number (ie 41091) - set analysis fails in QlikView

Calendar Picker sets variable as date number (ie 41091) - set analysis fails

Wed, 15 Jul 2015 17:46:51 GMT

I have a set analysis that is trying to sum if my Invoice Date is between variables iDateBeg and iDateEnd

When I choose my date from the Calendar Picker it sets the variables to the integer representation of the date and my set analysis fails.

sum({< Date_InvoiceDate = {">=$(iDateBeg)<=$(iDateEnd)"} >} Prod_SKU_CostTotal)

I tried this and it is still failing

sum({< Date_InvoiceDate = {">=$(date(iDateBeg))<=$(date(iDateEnd))"} >} Prod_SKU_CostTotal)

Nicole-Smith — Wed, 15 Jul 2015 17:53:35 GMT

sum({< Date_InvoiceDate = {">=$(=date(iDateBeg))<=$(=date(iDateEnd))"} >} Prod_SKU_CostTotal)

Wed, 15 Jul 2015 17:58:23 GMT

I have a silly feeling i asked that one before...... rings a bell - thanks!