Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 794
  • Last Modified:

How do I compare the dates in text boxes.

How would I write this.  I’m trying to compare  the dates in two text boxes.  This is what I have, what’s wrong with it.

errors: invalid expression

Thanks!


string aa = TextBox1.Text.Trim();
        string bb = TextBox2.Text.Trim();
        if (aa =< bb)
        {
            Label6.Text = "Start date can not be earlier than today’s date";
            
        }

Open in new window

0
bmanmike39
Asked:
bmanmike39
  • 2
  • 2
  • 2
  • +5
1 Solution
 
Paul JacksonSoftware EngineerCommented:
try this :
if (aa <= bb)
0
 
Paul JacksonSoftware EngineerCommented:
however you would be better doing this :

string aa = TextBox1.Text.Trim(); 
        string bb = TextBox2.Text.Trim(); 

        datetime startDate;
        datetime endDate;
        startDate = new DateTime();
        endDate = new DateTime();
        startDate = DateTime.ParseExact(aa, "yyyy-MM-dd HH:mm tt", null);
        endDate = DateTime.ParseExact(bb, "yyyy-MM-dd HH:mm tt", null);
        if (DateTime.Compare(startDate,endDate) < 0 ) 
        { 
            Label6.Text = "Start date can not be earlier than today’s date"; 
             
        }

Open in new window


Here is a link explaining DateTime.Compare : http://msdn.microsoft.com/en-us/library/system.datetime.compare.aspx
0
 
Rahul AgarwalTeam LeaderCommented:
Another way of doing this through AJAX is :

Date Formats for Ajax CalendarExtender Control

Format=”MMMM d, yyyy”  Result is April 28, 1906

=”dd/MM/yyyy”    Result is 23/11/2008

=”MM/dd/yyyy”    Result is 12/28/2008

=”dd-MMM-yyyy” Result is 23-Mar-2008

Comparing Two dates

If second textbox1(DespatchOrder) date value is less than to first textbox2(OrderTaken) date value then alert box will

display “Check date values”.This TextBox2_TextChanged event is fired when textbox2 is less than textbox1 date value.

Default.aspx Page: When using ajax controls paste script manager in aspx pages top. Check Date Formats in ajax calender
must be in dd/MM/yyyy

Ajax CalendarExtender1 both PopupButtonID=”TextBox1¿    and  TargetControlID=”TextBox1¿

Ajax CalendarExtender2 both PopupButtonID=”TextBox2¿    and  TargetControlID=”TextBox2¿

When you click Textbox1 or Textbox2 Calender control will popup you can choose the dates from there

Design Code

<table style=”border: 1px solid #000000; font-family: Arial, Helvetica, sans-serif; font-size: 9pt; background-color:

#E6E6E6¿>
<tr>
<td>OrderTaken</td>
<td>
<asp:TextBox ID=”TextBox1¿ runat=”server”></asp:TextBox>

<cc1:CalendarExtender ID=”CalendarExtender1¿ runat=”server” Format=”dd/MM/yyyy”
PopupButtonID=”TextBox1¿ TargetControlID=”TextBox1¿>
</cc1:CalendarExtender>

</td>
</tr>

<tr>
<td>
DespatchOrder</td>
<td><asp:TextBox ID=”TextBox2¿ runat=”server” AutoPostBack=”True”
ontextchanged=”TextBox2_TextChanged”></asp:TextBox>

<cc1:CalendarExtender ID=”CalendarExtender2¿ runat=”server” Format=”dd/MM/yyyy”
PopupButtonID=”TextBox2¿ TargetControlID=”TextBox2¿ >
</cc1:CalendarExtender>

</td>
</tr>

</table>

Default.aspx.cs code: Double click in TextBox2

protected void TextBox2_TextChanged(object sender, EventArgs e)
{
DateTime a = DateTime.Parse(TextBox1.Text);
DateTime b = DateTime.Parse(TextBox2.Text);

if (a > b)
{
Response.Write(”<script>alert(’Check date ranges to OrderTaken and OrderDespatch’);</script>”);
TextBox2.Text=””;
}
}

***Now Run the project Enter Textbox1 value as 09-02-2008

TextBox2 value as 02-02-2008

then textbox changed event fires and popup alert message “check date ranges to orderTaken and orderDespatch”

Note: You can write in this format also javascript alert message

Response.Write(”<script language=’javascript’>”);
Response.Write(”alert(’Please Check date ranges to OrderTaken and OrderDespatch.’);”);
Response.Write(”return false;”);
Response.Write(”<” + “/script>”);

Note: You can compare date formats like above figure but change the ajax calender control formats i.e Format=”dd-MMM-yyyy”
<cc1:CalendarExtender ID=”CalendarExtender1¿ runat=”server” Format=”dd-MMM-yyyy”
PopupButtonID=”TextBox1¿ TargetControlID=”TextBox1¿>
</cc1:CalendarExtender>

Similarly for calenderExtender2 Format=”dd-MMM-yyyy”
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
ninusajilCommented:
DateTime startdate=DateTime.ParseExact(TextBox1.Text,"dd/mm/yyyy",null);
            DateTime enddate = DateTime.ParseExact(TextBox2.Text, "dd/mm/yyyy", null);
            if (enddate > startdate)
            {
                //process
            }
0
 
AndyAinscowFreelance programmer / ConsultantCommented:
I would suggest you use Datetime picker controls for entering the dates on your form (unless there is a good reason they would not be suitable).  By using those it is impossible for the user to enter an incorrect date - with a text box one could enter, by mistake, 30.02.2010 (February never has 30 days)
0
 
Anurag AgarwalCommented:
hello bmanmike39 !!

I think u only need this ..........

Dim dt1, dt2 As New DateTime
        dt1 = TextBox1.Text
        dt2 = TextBox2.Text
        If DateTime.Compare(dt1, dt2) = 0 Then
            Response.Write("Same Date Time")
        ElseIf DateTime.Compare(dt1, dt2) < 0 Then
            Response.Write("dt2 is bigger")
        ElseIf DateTime.Compare(dt1, dt2) > 0 Then
            Response.Write("dt1 is bigger")
        End If

0
 
kovilpattiBaluCommented:
can use .. Convert.ToDateTime() also
0
 
mr_nadgerCommented:
go with Kovil's Convert suggestion, just be sure to validate the contents of the boxes first.
0
 
bmanmike39Author Commented:
DateTime startDate = DateTime.ParseExact(TextBox1.Text, "dd/mm/yyyy", null);
        DateTime endDate = DateTime.ParseExact(TextBox2.Text, "dd/mm/yyyy", null);
        if (endDate == startDate)
        {
            Label6.Text = "End date can not be equal to start date";
       }

Error:  String was not recognized as a valid DateTime.

0
 
AndyAinscowFreelance programmer / ConsultantCommented:
>>Error:  String was not recognized as a valid DateTime.

That is why I made my earlier comment:

I would suggest you use Datetime picker controls for entering the dates on your form (unless there is a good reason they would not be suitable).  By using those it is impossible for the user to enter an incorrect date - with a text box one could enter, by mistake, 30.02.2010 (February never has 30 days)
0
 
bmanmike39Author Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
  • 2
  • +5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now