Remove weekends from date fields
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
I have data like shown below. I have two date fields which date1 and date 2 and date difference field is date2 -date1 and it is in seconds. So what i want is i have to remove the weekends(Sat, Sun) when i subtract the date2 from date1 field. like for example
1/27/2021 16:26 | 2/1/2021 11:05 | 412714 |
here the difference the dates are from 1/27 to 2/1. So i want to remove the weekends which is 1/30 and 1/31 which Sat &Sun when i subtract date2 and date1. Can any one help me on this issue? I appreciate your help in advance. Thanks!
Date1 | Date2 | Date Difference in Seconds |
3/18/2020 2:17 | 3/20/2020 14:43 | 217565 |
9/3/2020 14:51 | 9/14/2020 14:17 | 948395 |
8/31/2020 16:42 | 8/31/2020 16:42 | 34 |
10/15/2020 14:43 | 10/20/2020 20:06 | 451411 |
10/22/2020 17:00 | 10/23/2020 11:28 | 66536 |
9/25/2020 16:06 | 9/29/2020 19:15 | 356941 |
9/29/2020 19:55 | 10/9/2020 19:18 | 861795 |
10/1/2020 15:51 | 10/1/2020 16:08 | 1065 |
10/1/2020 21:14 | 10/13/2020 21:57 | 1039357 |
10/2/2020 15:26 | 10/14/2020 15:42 | 1037755 |
10/2/2020 15:44 | 10/14/2020 15:53 | 1037331 |
10/2/2020 16:34 | 10/2/2020 16:40 | 331 |
10/5/2020 14:13 | 10/15/2020 4:23 | 828620 |
10/5/2020 14:34 | 10/15/2020 4:26 | 827526 |
10/5/2020 16:55 | 10/15/2020 18:49 | 870855 |
10/5/2020 17:45 | 10/15/2020 19:07 | 868897 |
10/5/2020 18:22 | 10/15/2020 20:41 | 872345 |
1/27/2021 16:26 | 2/1/2021 11:05 | 412714 |
- Labels:
- Best Practices
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Pinky,
I built a workflow that will identify weekends and calculate the total number of seconds. You can add this workflow onto your previous workflow which calculates the difference in seconds. I hope it helps!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This works as expected. Thanks for your reply.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Pinky, if my above post resolved your question, could you please mark it as a solution? Having this post marked as solved improves the community search engine for others seeking solutions, and I would greatly appreciate it. Thanks!
If it didn't resolve your question, I'm happy to keep working with you to find a solution!