Simple way to populate a List with a range of Datetime

user_396200 0
Viewed 4851

I trying to find a simple way to solve this.

I have a Initial Date, and a Final Date.

And I want to generate a List<Datetime> with each of the dates in a given period.

Example : Initial Date is "2013/12/01" and Final Date is "2013/12/05".

And I want to automatically populate a list with

"2013/12/01"
"2013/12/02"
"2013/12/03"
"2013/12/04"
"2013/12/05"

What would you suggest me?

Thanks

datetime .net c#
5 Answers
var startDate = new DateTime(2013, 12, 1);
var endDate = new DateTime(2013, 12, 5);

var dates = Enumerable.Range(0, (int)(endDate - startDate).TotalDays + 1)
                      .Select(x => startDate.AddDays(x))
                      .ToList();
user_11638670 
for(var day = from.Date; day.Date <= end.Date; day = day.AddDays(1))
{
     list.Add(day);
}
user_24741750 
DateTime startDate = new DateTime(2013, 12, 1); // or any other start date
int numberOfDays = 5;
var dates  = Enumerable.Range(0, numberOfDays)
                       .Select(i => startDate.AddDays(i))
                       .ToList();
user_4700050

You can use Linq like:

DateTime startDate = new DateTime(2013, 12, 1);
DateTime endDate = new DateTime(2013, 12, 5);
List<DateTime> dates =
                      Enumerable.Range(0, ((endDate - startDate).Days) + 1)
                      .Select(n => startDate.AddDays(n))
                      .ToList();

For output:

foreach (var item in dates)
{
    Console.WriteLine(item.ToShortDateString());
}

Output:

01/12/2013
02/12/2013
03/12/2013
04/12/2013
05/12/2013
user_27119650

You can do something like this:

DECLARE @startdate datetime, @enddate datetime, @increment int
SET @startdate = '2013/12/01'
SET @enddate = '2013/12/05'
SET @increment = 0
WHILE DATEADD(dd, @increment, @startdate) <= @enddate
  BEGIN
    SELECT DATEADD(dd, @increment, @startdate)
    SET @increment = @increment + 1
  END

Inside the while loop you can put the values on a table or do whatever you wish instead of just printing them out.

user_30662120
Related