Formula Not working

[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

[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.