how to find Missing dates of two dates in asp.net C# code

Paul Rajs

hi Developers,

i want to get all Missing dates of two dates in asp.net C# code dynamically and i need to bind the dates. i have last Inserted record and Current date but i dont know how to bind the missing dates one by one.

this is my database Records

E001 07/08/2017

E001 08/08/2017

E001 11/08/2017

in this record 09/08/2017,10/08/2017 dates are missing i want to bind the two dates one by one.

if suppose my record is like

E001 01/08/2017

E001 11/08/2017

i want to bind the 10 missing dates of database.

friends if anyone of you know please suggest me to how i am done this task.

thanks with

Paul.S

"A man becomes what he thinks about"

5 Replies

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

Midhun Tp9y ago
Accepted answer
Hi,

Please try below code -
List allDates = new List();
        DateTime startingDate = Convert.ToDateTime("08/01/2017");
        DateTime endingDate = Convert.ToDateTime("08/11/2017");
        for (DateTime date = startingDate.AddDays(1); date < endingDate; date = date.AddDays(1))
            allDates.Add(date);
Paul Rajs9y ago
thanks mr,.Midhun and Tapan Patel thanks a Lot .

Paul.,S
"Man becomes what he thinks about"
Tapan Patel9y ago
there is a nice way to do that and it is pointed out on below link. Please take at the implementation of the same.
https://stackoverflow.com/questions/3388344/find-missing-dates-for-a-given-range
Paul Rajs9y ago
tank youMr.Midhun Could you please suggeest me some code in C#
Midhun Tp9y ago
Hi,
In SQL you can use below query -
DECLARE @dt1 Datetime='2017-08-01'
DECLARE @dt2 Datetime='2017-08-11'
;WITH ctedaterange
     AS (SELECT [Dates]=@dt1+1
         UNION ALL
         SELECT [dates] + 1
         FROM   ctedaterange
         WHERE  [dates] + 1<= @dt2-1)
SELECT [dates]
FROM   ctedaterange
OPTION (maxrecursion 0)