Hi guys,
I'm needing to create a workflow, and a part of it needs to filter a dates column, the results I need are from tomorrow (t+1), so I'm trying to use DateTimeToday until the following next 10 (t+10) working days, avoiding weekends, for sure. Just tried with several flows but couldn't make it.
If anyone gets it, will be appreciated.
Tks in advance!
Assuming your date fields are set as date data types, you could try to filter for tomorrow's date with something like [date field] = datetimeadd(datetimetoday(),1,"days"). I'm not sure I follow the +10 piece of this though, if you have any sample data that might help.
Thanks for you reply! Sure, I might be more specific with a sample, pretending we have column A, I would need as an output of the filter the column B, it would be the following 10 days, always starting from tomorrow date, in this case March 17th, avoiding weekends.
Thanks @Qiu! It's almost what I need, but I need the filter to bring 29 and 30 as well, cause last working day counting 10 from tomorrow 17th, is March 30th. I would need to have them included as well. Any idea of what might be failing? Or maybe on my end?
Thank you again!
@Facu
Modified a bit