Get No. Of Days From TextBox

Question

in my databasae table i have to coloumn

one coloumn for issueDate and one for leaveDate

i get issueDate and LeaveDate from database and show them in textbox

But the problem is

i want to get on no of days

for example

issue date =12/12/2014

leave date=12/10/2012

reamin=12-10=2

i want this kindly tell me how i can get only only days from textbox and calculate there difference??????????

Bhushan Gawale · Answer

If your application is going to be deployed worldwide and supports the localization - it might be possible that the users are entering dates in the textbox according to their cultures and hence the server code which parses the date might throw an exception. In such cases - it is highly recommended that you should always try to read the values in the UTC date time format and pass it as string to the server which then parses the UTC string to give you DateTime object. Read more info about converting date time to UTC here - http://praveenlobo.com/techblog/how-to-convert-javascript-local-date-to-utc-and-utc-to-local-date/ The server code should look something like this DateTime dateTime = DateTime.Parse(utcDateStringCultureInfo.InvariantCulture DateTimeStyles.AdjustToUniversal); Now about calculating the date difference - Its better to use the Linq providers like this int diffDays = System.Data.Linq.SqlClient.SqlMethods.DateDiffDay(date1 date2);

Md. Raskinur Rashid · Answer

i think this solution is perfect for you- DateTime issuedate = DateTime.Parse(12/12/2014); DateTime leavedate = DateTime.Parse(12/10/2012); int issuedate_Day = (int)issuedate.Day; int leavedate_Day = (int)leavedate.Day; Console.Write(Math.Abs(remain = issuedate_Day - leavedate_Day)); Console.Read();

Vulpes · Answer

If you want to get the difference between those two dates in days on say a button click and display the result in a third textbox then the following code should work: private void btnCalculate_Click(object sender EventArgs e) { if (txtIssue.Text.Length == 0 || txtLeave.Text.Length == 0) { MessageBox.Show(Both textboxes must be populated first); return; } DateTime issueDate = DateTime.Parse(txtIssue.Text); DateTime leaveDate = DateTime.Parse(txtLeave.Text); int days = (int)(leaveDate - issueDate).TotalDays; txtDays.Text = days.ToString(); }