Yep, tried that one. The problem there is that it converts it to that text string. Then when you want to do sorting and grouping on the report, it only allows "Each Value" or "Prefix Character" and not the day, week etc.
The day, week are crucial to my report.
Any other ideas? Is there an update query I can run which will delete that time section only from the date field?