Display count(=1) between start date and end date

Hi All,

i have a requirement to display count 1 if there is any product blocked/booked between 2 dates in cross tab?

cross tab has calendar date,product desc, and below count variable.

i tried using calendar date and sum(if( calendar date>=start date and calendar date<= end date)then 1 else 0)

getting error #computation error.

can anyone help with above error or am i missing anything.

i’m trying to count the active records between 2 dates.

ravi342 (BOB member since 2012-08-06)