>>Hey, whatever works... But, you may want to look at datepart and convert...
>>
>>SELECT left(convert(datetime,TB.Date,111),7) as Date, ...
>>WHERE ...
>>GROUP BY datepart(yyyy, TB.date), datepart(mm, TB.date)
>>
>>>
>>>I want the output to be yyyy/mm.
>
>
>The result is displaying "Apr 2 " and I want 2001/04

May this can help. If I do a "SELECT convert(datetime,TB.Date,111) as Date, ", I see "2001-04-02 00:00:00.000" displayed. Why the Left statement simply returns the 7 left characters?