We have this problem in our company:
We are running a firebird database and i am using a date field as a parameter in the report.
But i only can use a string-parameter instead of a date field though it is a date data type in the database.
The reason seems to be that crystal report is sending the parameter formated like this:
if i add it in the query like this
i get a convert error (seems like our db cant use convert), if i add it like this
i get an error message, unknown token
So what can i do now? I want to use a date parameter to use the calender function, that would be much better for our customers. So far i have to type the date manuelly and the report is functional but a real date function is missing now.
Hope someone can help me im looking forward to your replies.
P.S. dont know if its important, i am using Crystal Reports 2008 Version 184.108.40.2063