01-17-2024 01:48 AM - edited 01-17-2024 01:49 AM
I have 2 date values, have to find the difference between both of them. Weekends to be excluded.
I am using the below expression to derive the value.
parseInt((Date.parse($Date2.toString())-Date.parse($Date1.toString()))/(1000*60*60*24)*0.71)
This logic is failing when
1. Date1 and Date2 are in the same week(for example 15/01/2024 and 19/01/2024)
2. Date 1 and Date2 are in different weeks but the difference is less than 7 days(19/01/2024 and 24/01/2024)
01-17-2024 02:13 AM - edited 01-17-2024 02:14 AM
Hello @kumar25.
Attached below is a sample pipeline that you can use.
In general, as a short explanation, I was following the steps below:
Let me know if you have any questions and if this helps you.
Regards,
Aleksandar.
01-17-2024 03:04 AM
Thanks @Aleksandar_A , it worked as required.