Computer Aided Design - CAD > Compass Design Automation > Archive > 2007-10-14 Latest [ Topics | Posts ] Archive Post A New Topic select distinct(InfoDate) as InfoDate,MonthName(InfoDate) as Month,left(InfoDate,7) yearmonth from ForumInfo005337 where InfoParentID=0 order by InfoDate desc; error