Dean,

Never heard about such problem with grouping on date fields. Is it VFP8? If it's, take a look at help under Behavior Changes Since Visual FoxPro 7.0 and in INFO: SQL SELECT Behavior Changes in Visual FoxPro 8.0 mskb #813361.


>I was doing some queries and I noticed that when one of the selected field is a date field, the GROUP BY statement gives an "invalid group by ..." error.
>