Question: Use the DATE ( . . . ) function to add months to the previous audit date. You are not allowed to use the EDATE
Use the DATE function to add months to the previous audit date. You are not allowed to use the
EDATE function.
Document your function NextAuditCSA using the design recipe linked in the syllabus prefix.
Improve your function NextAuditCSA by making it modular. We want to separate the concern of the
business rule from the concern of how to apply it to the data. Define a function NextAuditCSA which
takes the business rule as a function argument.
NextAuditCSA has the arguments as shown in this LAMBDA:
LAMBDAlastaudit,companysize,auditresult,businessrule,LET
where businessrule is defined by the above LAMBDA. Make use of the LAMBDA helper function MAP
to implement NextAuditCSA.
The modular function NextAuditCSA has the benefit that it is easy to change the business rule simply
by giving another businessrule function as an actual argument.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
