I have created a report which is connected to an Oracle database and is
called by a VB app..  The report when run for 23/05/1998 expects 5 records
but only gets 3.  The reason for this is that in the date column in the
table in question date and time are represented, and the 2 missing records
contained actual time ie 10:34:45 as opposed to 00:00:00 or12:00:00.

    This problem can be eliminated in Oracle by using a Trunc() function but
Trunc will not work in my selection formula in VB.
My selection formula looks like the following:

If Not CurrentReport.SetSelectionFormula("{TRN_STATUS_HISTORY.POST_DATE} =
Date(" & frm.sStartDate & ")") Then
                End If

Does anyboby know a Trunc equivalent for Crystal or any suggestion to get
around this problem.

Thanks ,
Aidan