Question: vii. Add a new field named DAYS_TO_PAY. Write the formula that calculates the number of days between the invoice date DATE_FIXED and the cash receipts

vii. Add a new field named "DAYS_TO_PAY". Write the formula that calculates the number of days between the invoice date "DATE_FIXED" and the cash receipts date "CR_DATE" Evilalive Eid tor Enation AND CA NOT MOY EXPO Functions Mmeric ghatations we waldie by i Conditional operations such as date arthritic, statistical Custom Functions calculations arid beat They are very ainbar in sayla and operation to functions found in other software packages such as hemal Test Equavice Record humber: based upon the parameters posed to the OFunction tel Dec g Round(Amount) wa INVOKE NO Nameric Found it. Seid called "Around" DATE to the nearest whole number. CUSTOMER NO Nameric GROSS SALES Nameers Adiboral help on SMES.DISCOUNT Nameric @Functions Is available by selecting the received NET_SALES Namark Oilfunction in the Jet th It
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
