Hi,


I am using crystal 10 and this is the query iam trying to write in add command line

select * from pview where
trunc(trandate)= to_date('{date1}','mm/dd/yyyy')


I have defined date1 as datatype date.

This always returns missing paranthesis error


I run this query and

select * from view1 where
trunc(trandate)= to_date('01/01/2009','mm/dd/yyyy')

fetches data with no hassle


1) is it something wrong with 'trandate' field Iam using, bcos I have same type of query on other date datatype fields while creating reports in same crystal version in the past.

2)Is it because of the view on which iam querying. i dont think so because I can run same query in sql developer and come up with results.


please advise

Nammu