How to find Date differences(dd/mm/yyyy)?

[irkahc]

Hi all, there are two textboxes in my page. FromDate and ToDate. dates are selected from popup calender and displayed in respective textboxes. when I click on a button, have to satisfy the following conditions.It is working with MM/dd/yyyy format.. but when I change the format to dd/mm/yyyy getting error.. 1. Difference between FromDate and ToDate sholud not greater than 31. 2. FromDate should be less than ToDate. 3. ToDate is not greater than current date. below is the code I had written: This code is working fine with MM/dd/yyyy date format.. but when I give the date in dd/mm/yyyy getting error. TimeSpan tsDaysDifference = Convert.ToDateTime(txtToDate.Text).Subtract(Convert.ToDateTime(txtFromDate.Text)); if (tsDaysDifference.Days > ConInterfaceManagerCommon.DATE_RANGE) { StringBuilder strbldrErrorScript = new StringBuilder(""); strbldrErrorScript.Append("alert('Difference between from and to dates should not morethan 31')"); strbldrErrorScript.Append(""); ClientScript.RegisterClientScriptBlock(this.GetType(), "Error", strbldrErrorScript.ToString()); return false; } else if (tsDaysDifference.Days < ConInterfaceManagerCommon.DATE_MINIMUM) { StringBuilder strbldrErrorScript = new StringBuilder(""); strbldrErrorScript.Append("alert('From date should be lessthan todate')"); strbldrErrorScript.Append(""); ClientScript.RegisterClientScriptBlock(this.GetType(), "Error", strbldrErrorScript.ToString()); return false; } else if (Convert.ToDateTime(txtToDate.Text) > DateTime.Now) { StringBuilder strbldrErrorScript = new StringBuilder(""); strbldrErrorScript.Append("alert('To date should be lessthan current date.')"); strbldrErrorScript.Append(""); ClientScript.RegisterClientScriptBlock(this.GetType(), "Error", strbldrErrorScript.ToString()); return false; } else return true; Can anyone help how to find the date difference in dd/mm/yyyy format on serverside? Many Thanks

[Jim Conigliaro]

When converting to a datetime object, you need to specify the format of the date if you are giving it a format other than the default for the server. Your server is expecting mm/dd/yyyy, so if you want to specify a different date format, you will need to tell the ToDateTime function what format you are providing the data in.

Jim Conigliaro jconigliaro@ieee.org
http://www.jimconigliaro.com