Passing Date from VB6 to Crystal Reports
Posted on 2003-03-15
I am using VB 6, MS Access and Crystal Reports 8. I need to have reports run for any date (only) entered by the user. Therefore, I need to acquire the date from the user, which I have done via a combo boxes (month, day, and year). And, I need to take this information and pass it to Crystal Reports to print the report for entered date only.
I am using MS Access as the database The field is date/time, although just the date (short date) occupies the field. However, Crystal Reports seems to want a date/time stamp passed to it. However, I must not be using the proper syntax as I keep getting a blank sheet.
Any assistance appreciated.