Not getting all expected records due to date-time issue in the Oracle database 
Author Message
 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



Sat, 31 Mar 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. VB 6.0, Crystal Reports, getting date/time from Oracle 8.0

2. Compare date in form with date/time in form with date/time in database

3. ADO with Access Date/Time field not storing the time, just the date

4. Flagged with due date but not in Inbox...

5. Recorded Macro Does Not Work As Expected

6. Recorded Macro Does Not Work as Expected

7. URGENT: Slow Access Database due to MSJTER35 MSJINT35 Not Found

8. Handling error due to table not found in Access database

9. Task's due date and reminder date

10. dates and times in record need to become records I think

11. VBA date query - not getting current date

12. ADO Record Set Issue with Oracle 8i

 

 
Powered by phpBB® Forum Software