Unable to pass Dates as parameter in Crystal Enterprise

[Former Member]

Hi All,

I am trying to fetch data from SQL 2008 and generate Crystal on it.

I am using Crystal Enterprise.

For this I am trying to pass few parameters.

All parameters are working fine except Date parameter.

Can any one tell me how to pass Date?

and

In SQL my Date parameter is Date and Time where Time is always 00.00.00.000

And in Crystal it has 12 hour format thus time never comes to 00.00.00.000

Is this a reason for this error.

If so, whats the solution?

[abhilash_kumar · Accepted solution]

Hi Ayush,

If the timestamp is always going to be 00:00:00, you could create a 'Date' prompt in Crystal Reports instead and convert the database datetime field to date.

-Abhilash

[Former Member · Accepted solution]

Hi,

See these links:

I hope you got some idea..Follow Abhilash suggestion

Thanks,

DJ

[Former Member · Accepted solution]

I didit.
Thanks for your reply.
It was too simple.might be I was doing wrong way.
Pardon for that.