How to list down missed date from date field, excluding weekend (Saturday, Sunday).
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you share the data instead of a screenshot? Can you also explain the logic? For ID 1, why are July 9th and 10th not listed? Maybe because it's a weekend?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Luke
Thank you for your reply.
Yes, it's excluding weekends all the missing dates should list down.
Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How's this @Shibasisnamdev? It takes the Min/Max date for each ID, generates all days between those, excludes weekends, puts the dates into a format which match your original and then conducts a join based on that. Those that don't find a join from the right data source are the missing dates and so we just assign them an [Hours] amount of 8 and use a Select to format as desired:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here's one way, generating a row for each date between the min and max for each ID, then filtering out weekends:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Awesome...
Thank you so much @DataNath
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much Luke.
This community is really alike heaven of solutions for a new developer.