I'm a newbie, first report I ever worked on.  I have a text field that has dates entered into it (9/30/2007).  This field needs to be in my where criteria.  I would like to have the user enter a date range and then check this field and return records within this date range.  How do you convert a text value to a date value?

I appreciate your efforts to help.  I have seen the same information in the help screens of Crystal but since I've never had a Crystal class, never even opened the program until yesterday, I'm at a loss as how to apply the CDate function.  In Crystal "Select  Expert" I have added a tab for the field id_6 which is my text field, used the 'formula' choice and tried CDate{Workstat.ID_6} <="07/01/2007".  Am I approaching this correctly?

Edited by blkhills - 28 Feb 2007 at 9:10am