How can i do this functionality

Question

3.50/5 (2 votes)

See more:

hi every body

i have a functionlity like retrieve values between dates.

C#

string item1 = "01/01/2012";
string item2 = "01/31/2012";
string item3 = "03/06/2012";
string item4 = "03/06/2011";

if (item1 != String.Empty && item2 != String.Empty && item3 != String.Empty && item4 != String.Empty)
{
    if (item1 > item3 && item1 < item2)
    {
        //adding only between 01/01/2012 to 12/31/2012 values here......(item3 come here)
    }
    else
    {
        //adding only out of 2012 year values here......(item4 come here)
    }
}

//How can i do this Can you any body idea this

thanks in advance........

Posted 7-Jun-12 17:53pm

U@007

Updated 7-Jun-12 18:40pm

v3

Add a Solution

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

**JF2015** · Accepted Answer · 2012-06-07T18:11:00

Just to get you an idea use this code. It checks if items3 and item4 are in 2012 or not in 2012.

C#

public void InsertDates()
{
   string item1 = "01/01/2012";
   string item2 = "01/01/2013";
   string item3 = "03/06/2012";
   string item4 = "03/06/2011";
   string item5 = "03/06/2013";

   if (item1 != String.Empty && item2 != String.Empty && item3 != String.Empty && item4 != String.Empty && item5 != String.Empty)
   {
      DateTime tm1 = Convert.ToDateTime(item1);
      DateTime tm2 = Convert.ToDateTime(item2);
      DateTime tm3 = Convert.ToDateTime(item3);
      DateTime tm4 = Convert.ToDateTime(item4);
      DateTime tm5 = Convert.ToDateTime(item5);
      if (tm3 > tm1 && tm3 < tm2)
      {
         MessageBox.Show("item3 is in 2012");
      }
      else
      {
         MessageBox.Show("item3 is not in 2012");
      }
      if (tm4 > tm1 && tm4 < tm2)
      {
         MessageBox.Show("item4 is in 2012");
      }
      else
      {
         MessageBox.Show("item4 is not in 2012");
      }
      if (tm5 > tm1 && tm5 < tm2)
      {
         MessageBox.Show("item5 is in 2012");
      }
      else
      {
         MessageBox.Show("item5 is not in 2012");
      }
   }
}

VJ Reddy · Accepted Answer · 2012-06-07T18:25:00

Solution 2

The IsMatch method of Regex class can be used for this purpose as shown below:

C#

string item1 = "01/01/2012";
string item2 = "01/01/2012";
string item3 = "03/06/2012";
string item4 = "03/06/2011";

string[] dates = new string[]{item1,item2,item3,item4};
string year2012=string.Empty;
string otherYears = string.Empty;
foreach (string date in dates)
{
    if (Regex.IsMatch(date,@".*/\s*2012", RegexOptions.CultureInvariant))
        year2012 += string.Format("{0}{1}",
                        string.IsNullOrEmpty(year2012)? "" : ", ",date);
    else
        otherYears += string.Format("{0}{1}",
                        string.IsNullOrEmpty(otherYears)? "" : ", ",date);

}
Console.WriteLine (year2012);
Console.WriteLine (otherYears);

//Output
//01/01/2012, 01/01/2012, 03/06/2012
//03/06/2011

Posted 7-Jun-12 18:25pm

VJ Reddy

Updated 7-Jun-12 18:26pm

v2

Comments

Sergey Alexandrovich Kryukov 8-Jun-12 0:37am

Sorry, but this is not a good approach -- still working with strings, not dates.
Please see the answer by JF2015 and my comment to it.
(I did not vote this time.)
--SA

VJ Reddy 8-Jun-12 2:14am

Thank you, SA, for the comment.

I thought of converting to DateTime.
But, dropped the idea, as the OP wants to add dates of 2012 year into one group and all other remaining dates into another group, which can be achieved easily using Regex, without involving the overhead of conversion.

I do agree with you, the Conversion to DateTime would be useful, efficient and preferred approach if any other operation of DateTime is required.

Thank you :)

JF2015 8-Jun-12 0:40am

Although I prefer to convert the dates to the DateTime object, I really like your approach and I hate that I didn't think of it :) 5+

VJ Reddy 8-Jun-12 2:15am

Thank you very much, JF2015 :)

U@007 8-Jun-12 0:50am

thank you reddy.
5+

VJ Reddy 8-Jun-12 2:15am

You are welcome and thank you for voting and accepting the solution :)

codeBegin 8-Jun-12 2:19am

my 5

VJ Reddy 8-Jun-12 2:58am

Thank you, codeBegin :)

Manas Bhardwaj 8-Jun-12 5:21am

my 5!

VJ Reddy 8-Jun-12 5:58am

Thank you, Manas :)