passing date parameter in to sql script

[Macho123]

Hi I am using crystal reports 11 and I have a problem when I am trying to pass the date parametrs in to the sql script at the add command facility. I am getting the following error.

Failet to retrive data from the Database,
Missing right parantesis.

but when I run the same query in oracle it is working fine. could anybody help me out with this.

Thanks,
krant.

 

[kskid]

It says that you are missing a right parenthesis so the syntax is amiss here.

Without seeing the add command, it would be a little difficult and highly improbable for anyone of us to provide a solution to your problem.

 

[JMG1019]

pkra and kskid,

I have the same error when I try to pass a date to my command window. Here is the code which would receive the date....

AND ACCESS_LOG.ACCESS_TIME >= TO_DATE ('{?Start Date}', 'DD-MM-YYYY HH24:MI:SS')
AND ACCESS_LOG.ACCESS_TIME <= TO_DATE ('{?End Date}', 'DD-MM-YYYY HH24:MI:SS')