How to get all the dates between two dates in C#

Question

2.00/5 (1 vote)

See more:

I'm writing a code that takes two dates from the user and book a slot for that user and then the datepicker should disable that date so that other user cannot book the same day. I thought of storing all the dates in the array and making the datepicker disable all the dates in the array. How can I write my code To store The dates in array. Here Is my code which is giving me a error that Listtype cannot be converted into string[].

C#

public List<DateTime> GetDatesBetween(DateTime startDate, DateTime endDate)
    {
        List<DateTime> allDates = new List<DateTime>();
        for (DateTime date = startDate; date <= endDate; date = date.AddDays(1))
            allDates.Add(date);
        return allDates;

    }
    protected void Button1_Click1(object sender, EventArgs e)
    {
        DateTime starting=new DateTime();
       starting=DateTime.ParseExact(datepicker.Value,"dd-MM-yyyy",null);
        DateTime ending=new DateTime();
       ending=DateTime.ParseExact(date2.Value,"dd-MM-yyyy",null);


      String[] dates = GetDatesBetween(starting, ending);  
      }

Posted 9-Dec-14 4:11am

Member 11239022

Updated 16-Jun-21 20:45pm

Andreas Gieriet

v3

Add a Solution

6 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2014-12-09T04:29:00

You can't just treat a List<DateTime> as an array of DateTime values, it's more than that. You have to convert it, which is simple to do. But - you don't want to use strings, they really don't compare well when dealing with date based info!
There are three ways to deal with this:
1) Change the method to return an array of DateTime values:

C#

public DateTime[] GetDatesBetween(DateTime startDate, DateTime endDate)
    {
    List<DateTime> allDates = new List<DateTime>();
    for (DateTime date = startDate; date <= endDate; date = date.AddDays(1))
    allDates.Add(date);
    return allDates.ToArray(); 
    }

2) Use a List outside the method:

C#

protected void Button1_Click1(object sender, EventArgs e)
    {
    DateTime starting=new DateTime();
    starting=DateTime.ParseExact(datepicker.Value,"dd-MM-yyyy",null);
    DateTime ending=new DateTime();
    ending=DateTime.ParseExact(date2.Value,"dd-MM-yyyy",null);
    
    List<DateTime> dates = GetDatesBetween(starting, ending); 
    }

3) Convert the List to an array outside the method:

C#

protected void Button1_Click1(object sender, EventArgs e)
    {
    DateTime starting=new DateTime();
    starting=DateTime.ParseExact(datepicker.Value,"dd-MM-yyyy",null);
    DateTime ending=new DateTime();
    ending=DateTime.ParseExact(date2.Value,"dd-MM-yyyy",null);
    
    DateTime[] dates = GetDatesBetween(starting, ending).ToArray(); 
    }

TheRealSteveJudge · Answer 2 · 2014-12-09T04:24:00

1) The list declaration was wrong.

C#

public List<DateTime> GetDatesBetween(DateTime startDate, DateTime endDate)
{
    List<DateTime> allDates = new List<DateTime>();

    for (DateTime date = startDate; date <= endDate; date = date.AddDays(1))
    {
        allDates.Add(date.Date);
    }

    return allDates;
}

2) You can convert a list to an array by using the ToArray() method

C#

DateTime[] dates = GetDatesBetween(starting, ending).ToArray();

I corrected your code.

Praveen Kumar Upadhyay · Answer 3 · 2014-12-09T04:32:00

Change your code with below.

public List<DateTime> GetDatesBetween(DateTime startDate, DateTime endDate)
        {
            List<DateTime> allDates = new List<DateTime>();
            for (DateTime date = startDate; date <= endDate; date = date.AddDays(1))
                allDates.Add(date.Date);
            return allDates;
        }

I hope you have the code to disable Dates with datetimepicker.

DamithSL · Answer 4 · 2014-12-09T04:48:00

Using LINQ you can do the same with one line of code

C#

DateTime[] dates = Enumerable.Range(0, 1 + ending.Subtract(starting).Days)
          .Select(i=> starting.AddDays(i))
          .ToArray();

if you need string array

C#

string[] dates = Enumerable.Range(0, 1 + ending.Subtract(starting).Days)
          .Select(i=> starting.AddDays(i).ToString("dd-MM-yyyy"))
          .ToArray();

Andreas Gieriet · Answer 5 · 2014-12-09T12:59:00

Another approach with iterator pattern:

C#

private const static string DATEFORMAT = "dd-MM-yyyy";

C#

public static IEnumerable<string> GetRangeOfDays(DateTime startDate, DateTime endDate)
{
    int days = (endDate - startDate).Days;
    for(int d = 0; d <= days; d++)
    {
        yield return startDate.AddDays(d).ToString(DATEFORMAT);
    }
}

Using this:

C#

DateTime starting      = DateTime.ParseExact(datepicker.Value,DATEFORMAT,null);
DateTime ending        = DateTime.ParseExact(date2.Value,DATEFORMAT,null);
string[] datesAsString = GetRangeOfDays(starting, ending).ToArray();

Some hints:
- initialize the starting/ending variables with the value returned by the parsing method
- use iterator pattern (see also C# Iterator Pattern demystified[^]) to get a sequence of dates as stings
Cheers
Andi

Member 15250816 · Answer 6 · 2021-06-16T20:45:00

Solution 6

vStr = " Select * from tbl_Record where Date >= Cdate (#" + txtSDate.DateTime.ToString("MM/dd/yyyy") + "#) and Date < Cdate (#" + txtEndDate.DateTime.AddDays(1).ToString("MM/dd/yyyy") + "#)";

Posted 16-Jun-21 20:45pm

Member 15250816

Comments

Richard MacCutchan 17-Jun-21 3:41am

Already answered more than six years ago. Please focus on current problems.

How to get all the dates between two dates in C#

6 solutions

Solution 2

Solution 1

Solution 3

Solution 4

Solution 5

Solution 6

Add your solution here

Preview 0