Crystal Reports Convert string to date

Message

   Hi everyone. I am new to this forum and have seen the two previous questions about converting a string to a date.  My problem is slightly different as follows:

The organisation I work for uses Objective EDRMS tightly integrated with Crystal Reports XI.  

I am trying to create a report based on - Workflow Slips using the fields Workflow and Date Completed.

The date completed field is brought into crystal as a STRING and presents in the report as (for example) - Wednesday, 5 September 2007 12:59:54 PM.

This could be because Crystal is looking at a 'view' of the workflow slip and not the actual tables themselves.

I need a formula to convert the results of the Date Completed field to a date such as - 05/09/2007 (DD/MM/YYYY) - not including the day of the week or time.

I need to do this so I can use DISTINCTCOUNT on the Date Completed field (which currently doesn’t work because each 'time' is a unique time) combined with grouping to find out how many invoices have been completed for a date or range of dates and also grouped by workflow.

So in effect I should be able to produce a report for a date range of a week, that looks something like:

General Correspondence (workflow name)
03/09/2007 - 10
04/09/2007 - 5
05/09/2007 - 20
06/09/2007 - 6
Invoice Processing (workflow name)
03/09/2007 - 525
04/09/2007 - 572
05/09/2007 - 720
06/09/2007 - 660