>I wasn't sure, so I went back to the table and saw that it is a DATE data type, not the DATETIME data type.
Do you have two records for that customer for that date? Do all the records get selected if you don't group? Try selecting into temp cursor first without grouping, then select from it with grouping - just as a way to debug.