Date Difference

[psenthilbtech]

Hi Team , 

Below is the sample data

FormName	Employee Name	Submission Date	Approval Date	Status	Days Under Review
Form1	Emp1	12/12/2018	12/20/2018	Rejected
Form1	Emp1	12/29/2018	12/31/2018	Approved	9
Form2	Emp2	12/13/2018	12/21/2018	Rejected
Form2	Emp1	12/26/2018	12/27/2018	Approved	5
Form3	Emp3	12/25/2018	12/25/2018	Approved
Form4	Emp	12/29/2018	12/31/2018	Approved

The Requirement is to find the Days Under Review -  Condition is Status = Rejected 

and then Difference between the Approval Date and Resubmitted Date based on Form Name

Regards,

Senthil

[sunny_talwar]

Is this something you need from the script or front end? Also, a Form can be rejected for one employee and approved by another?

[psenthilbtech]

Hi Sunny,

Script or Front End anything is ok for me.

It can be rejected by another user and approved by another user

[kaanerisen]

Hi,

You can try the script below.

LOAD
    FormName,
    "Employee Name",
     date(date#("Submission Date",'M/D/YYYY')) as "Submission Date",
    date(date#("Approval Date",'M/D/YYYY')) as "Approval Date",
    Status,
    IF(Status='Approved' and Previous(Status)='Rejected' and Previous(FormName)=FormName,date(date#("Submission Date",'M/D/YYYY'))-Previous(date(date#("Approval Date",'M/D/YYYY')))) as "Days Under Review"
FROM [lib://web2]
(html, utf8, embedded labels, table is @1);

Hope it helps..