Code Help??

[rohitians]

Hello,

I want count of number of brands in a period,

following is code help..

count(distinct(brand))

following code decides which brands

{< SKU_Launch_Date ={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}>}

not able to get it right...

Thanks and Regards,

Rohit

[tresesco]

Try placing $ around variables.

[#3]

Can you use this to get the variable value:

$(=vStartDate) and $(=vEndDate)

[Gysbert_Wassenaar]

Try:

{< SKU_Launch_Date ={'>=$(=Date($(vStartDate)))<=$(=Date($(vEndDate)))'}>}

It's possible you have to specify a date format too in the Date function. See this blog post: Why don’t my dates work?

[rohitians]

Thank you for your precious time,

count({< SKU_Launch_Date ={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}>}DISTINCT(BRAND))

I did this way and got the deired result..

Thanks .

Rohit