Tags: ENDOFMONTH

Compute month wise pending audits

{ 0 Comments }

Assume a three column dataset showing Audit ID, Date of receipt of audit mandate and Date of audit completion.  There are other columns as well but they are not important for our Analysis.  One may want to compute the following month wise: 1. Which (Audit ID) are the audits pending at the end of every […]

Read More →