
Not getting all expected records due to date-time issue in the Oracle database
Hi there!,
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