Page 1 of 1

Formula Not working

Posted: Fri Jan 30, 2009 1:59 pm
by mmurdock
This should work, but it doesn't. Any ideas?


{IIF(Round((DateDiff(varValueAsOf,kimr_equipment.date_received).days-60)/30) * (((kimr_equipment.acquisition_cost + Totals.Sum(kimr_po_distributions_band,kimr_po_distributions.cost_difference)) * .06)/12)>0,"Yes","No")}

I get the following error: Name 'DateDiff' is not declared.

Version 2008.3.317

Thanks,

Mat

Formula Not working

Posted: Mon Feb 02, 2009 6:42 am
by Edward
Hi Mat,

Thank you for this information.

And for now as a workaround you can modify your function as follows:

Code: Select all

{IIF(Math.Round((decimal)((DateDiff(varValueAsOf,kimr_equipment.date_received).Days-60)/30) * (((kimr_equipment.acquisition_cost + Totals.Sum(kimr_po_distributions_band,kimr_po_distributions.cost_difference)) * .06m))/12m)>0,"Yes","No")}
Thank you.