I created a report that needs to accept a date parameter. I am using CR8 and the data is in MS Access 97. The data type in Access is Date/Time.
Here is what I did:
First, I created a parameter with the type of string. I called it "DateParam".
Next, I created a formula to convert the string to a date:
DateValue(DTSToDateTime({?DateParam}))
I called this AuditDate. Last, I created a selection formula:
{qryAudit.Date} = {@AuditDate}
When I run the report and supply the date/time (01/02/2001 00:00), no records are returned. I have double checked the data and the date is valid. I have done this before with CR8 and Oracle8i and had no problems. I am connecting the report to a query in Access and not a table. Does this have something to do with it?
Here is what I did:
First, I created a parameter with the type of string. I called it "DateParam".
Next, I created a formula to convert the string to a date:
DateValue(DTSToDateTime({?DateParam}))
I called this AuditDate. Last, I created a selection formula:
{qryAudit.Date} = {@AuditDate}
When I run the report and supply the date/time (01/02/2001 00:00), no records are returned. I have double checked the data and the date is valid. I have done this before with CR8 and Oracle8i and had no problems. I am connecting the report to a query in Access and not a table. Does this have something to do with it?