Michael,
> Often there are multiple entries per day. I want to display the day
> once, with all the entries on that day.
Look in the docs under "Functions and Operators". There is a function
specifically to truncate dates. If you write a wrapper function around it,
you can even make it indexable ...
--
Josh Berkus
Aglio Database Solutions
San Francisco