Generating dates between monday and sunday

[wonka1234]

Hi, 

I am trying to generate every weekday using the end of week and beginning of week.

However when I summarize my data at the end of the year I am seeing Louis Stevens not having dates but Matt Smith having dates available.

I would expect them both to have equal number of dates. As you can see only Matt Smith has late december dates.

see attached workflow.

[geraldo · Accepted solution]

@wonka1234 

The problem is in the formula of the mult row tool.

When you change the name to Matt the formula is wrong.

The correct formula might be this:

IIF(isNull([Row+1:date] ) or [Staff Name] != [Row+1:Staff Name],DateTimeTrim([date],'LastOfMonth'),DateTimeAdd([Row+1:date],-1,'day'))

[binuacs · Accepted solution]

@wonka1234 You need to select the group by option for the Staff Name field