Formula Not working
Posted: Fri Jan 30, 2009 1:59 pm
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
{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