How can I avoid displaying duplicate dates in a date field? This field has been constructed from multiple different tables and the same date is displaying more than once both in a list box and a chart I have. Field is normalized to just show the date so time isn't causing the issue. Appreciate the help.
You probably have timestamps among your dates. 01/01/2015 00:00:00 and 01/01/2015 07:32 have the same date, but not same value. You can cut off the time part by using the floor function: date(floor(MyDate),'MM/DD/YYYY') as MyDate