topic Re: Date Difference in App Development

Date Difference

psenthilbtech — Mon, 20 Dec 2021 21:38:40 GMT

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

Re: Date Difference

sunny_talwar — Wed, 04 Sep 2019 12:34:44 GMT

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

Re: Date Difference

psenthilbtech — Mon, 09 Sep 2019 05:11:42 GMT

Hi Sunny,

Script or Front End anything is ok for me.

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

Re: Date Difference

kaanerisen — Mon, 09 Sep 2019 08:08:05 GMT

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..