hhclt
asked on
Need to display value is commit date is greater than two years, NM if date is less than two years
I need to display a value, but if the current date is less than two years from the initial commitment date, I need to display NM. When I try the formula below, I keep getting "a string is required here" for the (({V_fund_invest.outstand_ commit}/({ v_fund_inv est.distri bution} + {v_fund_invest.adj_value}) )
If CurrentDate - ({v_fund_invest.initial_co mmit_date} ) < 730 then "NM" else (({V_fund_invest.outstand_ commit}/({ v_fund_inv est.distri bution} + {v_fund_invest.adj_value}) )
If CurrentDate - ({v_fund_invest.initial_co
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER