Problem passing date in selection formula 
Author Message
 Problem passing date in selection formula

Here is the code I am passing to Crystal Reports

CrystalReport1.SelectionFormula = "{POL_CONTR.ENT_TISTMP}>= _
'Date(" + ccyy + "," + mm + "," + dd + ")'"

Immediate window:
?crystalreport1.SelectionFormula
{POL_CONTR.ENT_TISTMP}>= 'Date(1999,01,01)'

And Crystal returns the following error message:
Error in formula <Record Selection>.
'
'
The remaining text does not appear to be part of the formula.

What am I doing wrong?  I am sending this selection formula to
currently functioning crystal report.  I have other option buttons
that call the same report sending a different non-date selection
formula that works just fine.  Any ideas?



Tue, 17 Aug 2004 00:54:50 GMT  
 Problem passing date in selection formula
No quotations required before and after Date Function.

CrystalReport1.SelectionFormula = "{POL_CONTR.ENT_TISTMP}>= _
 Date(" + ccyy + "," + mm + "," + dd + ")"

Best Regards,

Luqman


Quote:
> Here is the code I am passing to Crystal Reports

> CrystalReport1.SelectionFormula = "{POL_CONTR.ENT_TISTMP}>= _
> 'Date(" + ccyy + "," + mm + "," + dd + ")'"

> Immediate window:
> ?crystalreport1.SelectionFormula
> {POL_CONTR.ENT_TISTMP}>= 'Date(1999,01,01)'

> And Crystal returns the following error message:
> Error in formula <Record Selection>.
> '
> '
> The remaining text does not appear to be part of the formula.

> What am I doing wrong?  I am sending this selection formula to
> currently functioning crystal report.  I have other option buttons
> that call the same report sending a different non-date selection
> formula that works just fine.  Any ideas?



Tue, 17 Aug 2004 01:01:55 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. passing date to record selection formula

2. How To Pass the Like Pattern in the Selection Formula

3. Passing multiple criteria (IN STATEMENT) to Crystal using Selection Formula

4. how to pass multiple selection formula

5. Help with using date variable in Crystal reports selection formula

6. Help: CR group selection formula with dates

7. Dates in selection formulas

8. Selection Formulas with Dates

9. selection formula with dates and times

10. Adding Date parameters to my selection formula - Please help a dummy

11. V6 Selection Formula for Date Range

12. date selection formula....

 

 
Powered by phpBB® Forum Software