Crystal Reports Report In Date Ranges

Message

Originally posted by kevlray

Interesting, so CR cannot find either {salesordes.sdate}, {?Report Date From} or {?Report Date End}.  I would double check the spelling of each of these (especially the parmeters).  I have sometimes had to resort to deleting my parameters and recreating them because I had somehow gotten a 'hidden' character in the name. 

Thanks for that, have check and DOUBLE checked that the tables are spelt correctly.  Have also tried this on a machine with CR9 and get the same error. have also sorted some data in SQL QA and yep THAT works on the salesorders.sdate

ok, to summerise AGAIN. 

i) I have my report and it pulls back 'lots' of data
ii) I click on SELECT EXPERT ( fingers and Marbles icon)
iii) select the New Tab
iv) select 'salesorders.sdate' from the field chooser box
v) make the two drop-down boxes read     IS     and    FORMULA
vi) put the following sql into the formual box

({salesorders.sdate}>=Cdate({?Report From})
and {salesorders.sdate}<=Cdate({?Report End})

vii) click on OK 
Viii) get the error :-

"A number, currency amount, boolean or string is expected here"

ix) click on the OK button
X) the cursor is still flashing after the last character where it was when i clicked on teh OK button in vii

!!!!