The first method you show to format the date allows to see the date in the desired format but am I mistaken thinking that it will not  allow a group by? I mean that although we visually see the dates with the desired format, access still sees it as the "real" value which is not formatted.
Thanks