pull data out from startdate:01/01/2002 to enddate: 12/31/2002. 1

[112055]

I want to be able to pull data out from startdate:01/01/2002 to enddate: 12/31/2002.
Is this correct ?
I put it inside Edit Selection Formula-->inside Record and Check and Accept it.
But everytime I Accept it , it ask me if I want to change the query. I do not want to change my existing query in my Show SQL Query. Is my sequence of steps or approach to it is wrong?


{D.DEAL_STATUS} = "F"
and
(year({D.DEAL_DT})= year(CurrentDate) and day({D.DEAL_DT}) = day(CurrentDate))

 

[synapsevampire]

Try:

{D.DEAL_STATUS} = "F"
and
{D.DEAL_DT}= cdate("1/1/2002&quot to cdate("12/31/2002&quot

By doing this, Crystal will alter the SQL sent to the database to optimize.

You're probably getting this message because you've altered the SQL manually, so copy out the SQL and paste it somewhere, then let CR update the SQL, then add back in whatever is different.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com