Crystal Reports Formating String field to Date data type/value

Message

   I am trying to generate a report from a text file which has fields delimited using the '|' characters. One of the fields section represents a timestamp, however when using the file its getting treated as type string by Crystal Reports XI.  

Can you somebody please suggest how Crystal Reports can be made to 
treat this as a 'date' data type.

Sample row from the text file:-

Mon Jan 14 00:15:03 EST 2008|230|http://www.xptopstories.com/login

I want Crystal Reports to treat the first field as a date value, i.e. 14th Jan 2008.

I need to do grouping, maximum, etc on this field treating it as a date.

Edited by anishpyne - 11 Feb 2008 at 11:48am