Skip to Content
0
Former Member
Dec 29, 2008 at 03:15 PM

How do i use a date parameter in this case?

48 Views

Hello.

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:

Date(10.10.2008)

if i add it in the query like this

{?date}

i get a convert error (seems like our db cant use convert), if i add it like this

'{?date}'

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 12.0.0.683