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

[#1]

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 · Accepted solution]

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

[#3]

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