As you can see from my first post I mentioned I set the nls_date_format.

I think because the column also contains time I need to do substr or something to exclude the time from the column.

As mentioned i only want to match the YYYYMMDD part and don't care
about the time. This way I will get back one row for every distinct case
as opposed to getting back several rows for the same date.