How to list the missing date?Please help.
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:
Hi @Shibasisnamdev
Here's one way, generating a row for each date between the min and max for each ID, then filtering out weekends:
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?
Hi LukeThank you for your reply.Yes, it's excluding weekends all the missing dates should list down.
Thank you
Awesome...
Thank you so much @DataNath
Thank you so much Luke.This community is really alike heaven of solutions for a new developer.
