Converting date/time to date in Crystal 8.5 1

[Hoppkins]

Hi.

I have 2 fields i want to perform a comparison on. The fields are date/time created and date completed.

I want the report to suppress any values where:

date/time created = date completed.

The problem is they will never equal as one field is in the format:

01/01/2000 13:27:02

and the other in the format

01/01/2000

Is there a way to change the date/time to just read the first 10 characters so it ignores the time part?

I tried the substring command but since it is a date type field it gave errors.

Thankyou

 

[MisterMo]

this will only compare the dates value of the two fields and ignore the time

Date({date/time created }) = Date({date completed})

Mo

 

[Hoppkins]

Awesome thanks that worked a treat!