compare given date with current date exclude weekends while comparing

[vnn2492]

I have a requirement where I need to extract errors stayed more than 48 hours on column "Changed on", to calculate 48 hours we need to ignore weekends, so If any of the error occurs over Fridays the error should wait for 48 hours by excluding weekends.

Year	ID	error  Vault	type of error	Changed On
2020/21	1221	error	system error	19/10/2021 18:00
2020/21	2341	error	output error	21/10/2021 11:35
2020/21	3456	error	system error	22/10/2021 10:20

can some one help me with this please ?

[atcodedog05]

Hi @vnn2492 

Can you provide some sample input and expected output it will help us get a better understanding of the usecase.

[vnn2492]

Hi @atcodedog05

Here is the sample input attached below in the table 

Year	ID	error  Vault	type of error	Changed On
2020/21	1221	error	system error	19/10/2021 18:00
2020/21	2341	error	output error	21/10/2021 11:35
2020/21	3456	error	system error	22/10/2021 10:20

and the expected output would be :
I need a difference between current date to " changed on" from the input table.

if the " type of error " stayed more than 48 hours? have to separate those records. while calculating 48 hours I need to ignore weekends as errors are not handled during weekends.

so for example: if any error is occurred on "Friday 22/10/2021" and you are finding difference on 25/10/2021: in this scenario you have to ignore Friday as the error is not yet stayed more than 48 hours 

[Qiu · Accepted solution]

@vnn2492 

I hope I understand it correctly.

[vnn2492]

Thank you for your response,

here we need to find the difference between the column " changed on" to "current date"

and I need to separate the difference which is having grater than 48 hours. But we need to ignore weekends 

if any error is occurred on Friday  it has to wait for 48 hours as weekends are not calculated, so error will stay and will not calculate difference for this type of records.

[vsoni]

one way of solving this is to minus 48 hours from the error time where the day is a friday to account for the weekend:

[vnn2492]

Thanks lot !

it helped me 🙂