I am querying in my Table for Distinct Product Details. Now I have to filter Data based upon Date Column present in Table. The column having Dates have Data Type Varchar2. But I am not getting any result whereas Data is present in that Daterange. WEEK\_DATE is my Date Column.

```
select distinct PRODUCT
from Table1
where WEEK_DATE between '12/31/2012' and '06/19/2017'

```

Some Sample Dates

```
2014-03-31
2014-09-01
2014-12-15
2014-12-22

```