[Need Help] Select dates where db column is a varchar

Hello to all. I'm trying to make a report where the date column is stored as a varchar (I really dont know why they did it like that). When I use the Select Expert and make a date range, the report comes out wrong giving other dates. For example if I use in between 08/01/2008 and 09/30/2008 it returns dates from 1999, 2000, ect.....

Any way I can convert that db column from string to date and then make the comparation.

Thanks

How is the date formatted in the varchar field? Crystal has several Date Functions but the method you choose depends on the format of the date string.

Quote:

---

Originally Posted by brucevde

How is the date formatted in the varchar field? Crystal has several Date Functions but the method you choose depends on the format of the date string.

---

The date is formated mm/dd/yyyy

Thanks