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

[chaguito]

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

[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.

[chaguito]

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