i got select an qry :
"select distinct monthname(RDate) as monthname,mid(RDate,1,4) as year,sum(case when Type = 'Got No R' then 1 else 0 end) as NoR,sum(case when Type = 'Got R' then 1 else 0 end) as GOTR from sample where RDate between '"
& a & "-" & c & "-%' and '" & b & "-" & d & "-% ' group by monthname,year order by year,monthname;"then, my categories will be monthname&year such as March2008 but, my output was System.Byte[]. why ?
in the database, RDate datatype is date. got any solution ?
thanks
