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.

Tks.
   Bill