Skip to main content

Timeline for Logic to exclude weekends in flow

Current License: CC BY-SA 4.0

15 events
when toggle format what by license comment
Jan 6, 2023 at 12:36 vote accept SBS
Jan 6, 2023 at 11:39 comment added SBS Hi Chris, I just saw the answer you wrote. Somehow i figured the same Weekday function for my requirement. I hope it should work while I test. Thanks a ton.
Jan 6, 2023 at 11:11 comment added Chris I have update the solution and described how to test for week day
Jan 6, 2023 at 11:11 history edited Chris CC BY-SA 4.0
added 454 characters in body
Jan 5, 2023 at 13:10 comment added SBS I am finding it difficult to check whether the flow variable {!$ Flow. CurrentDate} is a weekend or weekday inside flow. Can you suggest a formula?
Jan 5, 2023 at 7:42 comment added Chris Well it depends the level of precision you require, with my proposition you can display the field number of working days to business users, they can see it all the time in the record page layout. Now this field gets recalculated once per day, maybe that's enough for your requirement ?
Jan 5, 2023 at 5:22 comment added SBS Great effort Chris!! But the thing is Business user wants to see the status every now and then. Actually the purpose here is to Calculate SLA like whats the status of the service created and whether its nearing SLA timeline days. Can we achieve that in Record triggered flow? Thanks in Advance.
Jan 4, 2023 at 17:31 comment added Chris if you want to not take into account the week-ends then you need to add additional logic in the flow to test if current day is Saturday or Sunday, but it's not difficult.
Jan 4, 2023 at 17:28 history edited Chris CC BY-SA 4.0
added 117 characters in body
Jan 4, 2023 at 17:21 comment added Chris ok updating my answer
Jan 4, 2023 at 17:19 history edited Chris CC BY-SA 4.0
added 303 characters in body
Jan 4, 2023 at 16:59 comment added SBS Hey! Thanks for your effort. If possible help me with Flow because I am pretty new to Batch.
Jan 4, 2023 at 16:27 history edited Chris CC BY-SA 4.0
edited body
Jan 4, 2023 at 16:10 history edited Chris CC BY-SA 4.0
added 282 characters in body
Jan 4, 2023 at 16:05 history answered Chris CC BY-SA 4.0