SOLVED
Generating dates between monday and sunday
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
wonka1234
10 - Fireball
‎05-29-2023
11:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
Labels:
- Labels:
- Custom Tools
2 REPLIES 2
geraldo
13 - Pulsar
‎05-29-2023
01:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
21 - Polaris
‎05-30-2023
02:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/9AF25434D4F136B28264A96CA92E8A93/responsive_peak/images/icon_anonymous_message.png)