Agree with above - I used the following seq. to get at your problem
- create a date and time range fixed for 1 day
- extract date and time fields to get day of week number and day of week name (really just need number)
- Rule engine
$Day of week (number)$ =1 => 1
$Day of week (number)$ =2 => 0
$Day of week (number)$ =3 => -1
$Day of week (number)$ =4 => -2
$Day of week (number)$ =5 => -3
$Day of week (number)$ =6 => -4
$Day of week (number)$ =7 => -5
appending a new column called Start_index - date& time shift: select numerical column start_index with Granularity days
5) A second date time shift node with fixed number of days as 5
You always get Monday to Sat no matter what you put in . with Sunday you get the immediate Mon - Sat.
See complete flow here:
