Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"The string is non-numeric"

Status
Not open for further replies.

mikkom

Technical User
Jul 23, 2010
29
FI
I have in selection formula condition:
{@next_day} < {?end_date} //end_date is a parameter field

{@next_day}
datevar nextdt := {@begin_date};
numbervar i := {period};
while nextdt <= currentdate + i
do (nextdt := cdate(dateadd("d",i,nextdt)));
nextdt

When I try to run report I get error message: "The string is non-numeric". When I take off that condition from selection formula, report works fine. But then it shows all values.

Is it possible to get that condition work?
 
Hi,
What is the source of

{period}


and are you sure there are no blanks or NULLs or other non-numeric values in that source?

[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top