how can we compare DATEs in C#

Question

0.00/5 (No votes)

See more:

hi..
please tell me how can i compare the dates in the if condition..... m i doing it in the right way ?????

i m fetching the due_date from the database for comparision....

if the due_date is 2 days bigger then i want to perform some task... else something else

thanks

C#

string str1 = "select due_date from mConfirm where emp_id='" + s + "'";
           sda = new SqlDataAdapter(str1, cn);
           ds = new DataSet();
           sda.Fill(ds);

           string d = ds.Tables[0].Rows[0].ItemArray[0].ToString();
           if (Convert.ToDateTime(d) >= DateTime.Today)    // HERE WHAT SHOULD I DO
           {
               LblAlreadyExists.Text = "Already Under Process";
           }
           else
           {
               LblAlreadyExists.ForeColor = System.Drawing.Color.Red;
               LblAlreadyExists.Text = "RECORD ALREADY EXISTS";
               CHKConfirmed.Enabled = false;
               BtnConfirmd.Enabled = false;
           }

Posted 22-Feb-12 22:24pm

Tushar1999

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)

Shameel · Answer 1 · 2012-02-22T22:33:00

Solution 2

Try this:

C#

string d = ds.Tables[0].Rows[0].ItemArray[0].ToString();
DateTime dt = DateTime.Parse(d);
if (dt.AddDays(2) >= DateTime.Today)

This is just a demonstration. You can use AddDays, AddHours, etc. to make the code work for you. Also use TryParse instead of Parse.

Posted 22-Feb-12 22:33pm

Shameel

hoernchenmeister · Answer 2 · 2012-02-22T22:34:00

I would suggest to use DateTime.TryParse() first to check if it is a valid date.
For adding 2 days to a DateTime you could use DateTime.Now.AddDays(2) and then compare the two dates in your condition.
Keep in mind that there might be some time values within the date when using DateTime.Now that you might want to get rid of first.

Varun Sareen · Answer 3 · 2012-02-22T22:34:00

try this:-

string str1 = "select due_date from mConfirm where emp_id='" + s + "'";
           sda = new SqlDataAdapter(str1, cn);
           ds = new DataSet();
           sda.Fill(ds);
 
           string d = ds.Tables[0].Rows[0].ItemArray[0].ToString();
           if ((Convert.ToDateTime(d)- DateTime.Today)>=2)    // HERE WHAT SHOULD I DO
           {
               LblAlreadyExists.Text = "Already Under Process";
           }
           else
           {
               LblAlreadyExists.ForeColor = System.Drawing.Color.Red;
               LblAlreadyExists.Text = "RECORD ALREADY EXISTS";
               CHKConfirmed.Enabled = false;
               BtnConfirmd.Enabled = false;
           }

Convert.ToDateTime(d)- DateTime.Today

This subtracts two DateTime. The result is a TimeSpan object which has a Days property.

I hope this will work.

Bojjaiah · Answer 4 · 2012-02-22T22:35:00

Solution 5

hi
try this

DateTime dt;
           DateTime dt2;
           int datecompare = DateTime.Compare(dt,dt2);

Posted 22-Feb-12 22:35pm

Bojjaiah

how can we compare DATEs in C#

4 solutions

Solution 2

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0