Grouping by Year (1 Viewer)

[wgma]

I have a query that I need to group by the year of a date that is stored as a string , i.e. 20080630.

SELECT WGMAHIST_TIMEDTY.TDYLCL, WGMAHIST_TIMEDTY.TDYTDT, sum(WGMAHIST_TIMEDTY.TDYFND) AS Hrs
FROM WGMAHIST_TIMEDTY
WHERE WGMAHIST_TIMEDTY.TDYSSN=123456789
group by WGMAHIST_TIMEDTY.TDYTDT, WGMAHIST_TIMEDTY.TDYLCL

I know that this can be done but How?

Thanks

 

[pbaldy]

Try

Left(FieldName, 4)

 

[wgma]

I did that and it threw an error.

 

[pbaldy]

What was the error? Exactly how did you use it? What's the full SQL now?