Subtract dates using DateTime.Now

Question

0.00/5 (No votes)

See more:

Hi,

I have a Drop down List box, contains 'Last 7 days', 'Last 15 days' and 'Last 30 days'.

From this I need to get dates between DateTime.Now and DateTime.Now - 7 days

Please help me how to achieve this.

Thanks in advance

Posted 16-Oct-13 21:36pm

srmohanr

Add a Solution

4 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)

Khandwawala Hatim · Answer 1 · 2013-10-16T21:47:00

Use below code to populate your dropdown

DataTable dt_dates = new DataTable();
dt_dates.Columns.Add("Date");

for (int i = 0; i < 7; i++)
{
    DataRow dr_dates = dt_dates.NewRow();
    dr_dates["Date"] = DateTime.Now.AddDays(-i).ToShortDateString();
    dt_dates.Rows.Add(dr_dates);
}

Combobox.Datasource = dt_dates;
Combobox.databind();

ManojDhobale · Answer 2 · 2013-10-16T21:51:00

get startdate and enddate

DateTime StartingDate= DateTime.Now.AddDays(-30);

then get list of dates between these dates using below method

private List<datetime> GetDateRange(DateTime StartingDate, DateTime EndingDate)
{
if (StartingDate > EndingDate)
{
return null;
}
List<datetime> rv = new List<datetime>();
DateTime tmpDate = StartingDate;
do
{
rv.Add(tmpDate);
tmpDate = tmpDate.AddDays(1);
} while (tmpDate <= EndingDate);
return rv;
}

Gabriel Szabo · Answer 3 · 2013-10-16T22:12:00

Solution 3

C#

int count = 7;
var dates = Enumerable.Range(1-count, count).Select(i => DateTime.Today.AddDays(i));

Posted 16-Oct-13 22:12pm

Gabriel Szabo

Comments

Gabriel Szabo 17-Oct-13 4:15am

And remember not to run this code on midnight... ;)

srmohanr · Answer 4 · 2013-10-16T22:38:00

Solution 4

Use Substring to extract date/month and year

C#

string fr = DateTime.Today.ToShortDateString();
string from = fr.Substring(6, 4) + "-" + fr.Substring(3, 2)
 + "-" + fr.Substring(0, 2);

Posted 16-Oct-13 22:38pm