I am trying to use CF Report Builder because the client needs a pretty nicely broken out PDF report. If I could just get it to output the data, it is going to be VERY pretty. The code in the current HTML report is
<CFIF isdate(primaryreviewerdate)>#val(datediff("d", PrimaryReviewerDate, now()))#<CFELSE>0</CFIF> Days
Getting the error: If the expression is a string, ensure that it is within quotes. Error: iif(isdate(query.PrimaryReviewerDate), DateDiff(d, query.PrimaryReviewerDate, getdate()), DE("0 Days")) is not a valid ColdFusion expression.
Anyone have any ideas??
ColdFusion Language
Last Comment
Pravin Asar
8/22/2022 - Mon
Pravin Asar
Look at the working example. I simulated the query data, using QueryNew.
<cfscript>
query = QueryNew("ID,PrimaryReviewerDate","integer,varchar");
tt = QueryAddRow(query, 1);
tt = QuerySetCell(query, "ID", 1);
tt = QuerySetCell(query, "PrimaryReviewerDate", "12/1/2014");
value2=iif((isdefined ("query.PrimaryReviewerDate") && isdate(query.PrimaryReviewerDate)), DateDiff('d',query.PrimaryReviewerDate, Now()), "O days");
WriteOutput ("Diff is :" & value2);
</cfscript>
What kind of data field is PrimaryReviewerDate in your query ?
<cfscript>
query = QueryNew("ID,PrimaryReview
tt = QueryAddRow(query, 1);
tt = QuerySetCell(query, "ID", 1);
tt = QuerySetCell(query, "PrimaryReviewerDate", "12/1/2014");
value2=iif((isdefined ("query.PrimaryReviewerDat
WriteOutput ("Diff is :" & value2);
</cfscript>
What kind of data field is PrimaryReviewerDate in your query ?