Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

How to get missing records in a month?

Home
Forums
LINQ

How to get missing records in a month?

shosho s

10yAsked Oct 23, 2016, 8:21 AM886LINQ

I have a table in which i record the user time in and time out daily in a month.

So lets suppose today a user didnt time in /time out (and there could be many more days in a month.)

How can i get these records per month excluding the weekend which is Friday and Saturday?

Thank you in advance

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Nitin Sontakke10y ago
If you are using sql server, all you have to do is, have a table variable with rows with all the required dates in that table.
The select from that table and left outer join (or cross join) with attendance table, you get the all the dates and null next to dates where there is no data.
0
Midhun Tp10y ago
Hi,

Please find the relative solution in sql-
http://marlonribunal.com/finding-gaps-in-or-missing-dates-using-tsql/

Also have a look at below threads for something similar done with linq-
http://stackoverflow.com/questions/1468637/filling-in-missing-dates-using-a-linq-group-by-date-query
http://stackoverflow.com/questions/35062144/find-missing-date-in-listdatetime-and-insert-that-date-on-the-right-index
0