Newbee HELP with VB6 Crystal Reports Date search 
Author Message
 Newbee HELP with VB6 Crystal Reports Date search

I am using VB6 and Crystal Reports to search our customer database (MS
Access) to find
all the orders from a specified start and end (month day year)

The selection formula line below is working, but its Date search is
coded using a fixed Date, I would like to use variable start and end
search dates using the Calendars in VB6.
CalendarStart = 01/01/1994   CalendarFinish = 12/31/1994

CrystalReport1.SelectionFormula = "{ORDERS.DATE} in Date (1994, 01,
01) to Date (1994, 12, 31)"

When I change the CrystalReport1.SelectionFormula to
"{ORDERS.DATE} in Date (CalendarStart) to Date (CalendarFinish)"
I get a Run-time error 20515  Error in formula.
Any HELP in correcting  this Error would be greatly appreciated.


Sat, 29 Nov 2003 19:57:09 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Crystal Reports (Date Searching)

2. VB6 User-Defined Dates for Crystal Report

3. VB6.0, Crystal Reports, date/time from Oracle

4. Crystal Report NEWBEE Question

5. Newbee Crystal Report Question

6. NewBee Crystal Report[Q]

7. Crystal Reports 8.5 (VB6) to Crystal Reports NET (VB.NET) conversion

8. Help: VB6 Crashes after adding Crystal Report 6.0 Designer report

9. I search a help of Crystal REports for Visual Basic 5

10. Crystal Report Date Vrs Sql Server Date

11. Crystal Reports 8.5 date range parameter field - record selection that includes null date range

12. Help with using date variable in Crystal reports selection formula


Powered by phpBB® Forum Software