I have a report that displays data from a field in a table named rlmain.logdate. Each entry in that field is a date and time. The issue is that A) I only need to pull the date of each entry, and B) I only need 1 entry per date. The way our software stores the data in this table, you may have the same date but with multiple time stamps and again, it stores the date AND time in that one field.

Even if I can't parse out the time part of the entry, I only need one entry per date to display. I have this grouped by a field named apnames.desc.

Thanks for any help anyone could give!