how to findout days between two dates selected by asp calender

Question

4.00/5 (1 vote)

See more:

i have to calenders
and two textboxes

one is from : textbox1 and calender1
2nd is to : textbox2 and calender2

when i select a date .. in calender1 it shows slectd date in textbox1
and when i select a date .. in calender2 it shows me selectd date in textbox2

Now i placed a label . in which i want that the days between the two 'FROM' and 'TO' TEXTBOXES will b shown in in LABEl

FOR EXAMPLE:
when i selectd FROM date : 23/3/2012
and TO date : 2/4/2012

the label show me the number of days in LABEL . in this case.. which will be "7 DAYS"

i tries to do this task with this code

C#

protected void Button1_Click(object sender, EventArgs e) 
       { 
           DateTime dt1 = Calendar1.SelectedDate; 
           DateTime dt2 = Calendar2.SelectedDate; 
           TimeSpan ts = dt2 - dt1; 
           int numberOfDays = ts.Days; 
           Label3.Text = numberOfDays.ToString(); 
       }

but not found my desired result,

Posted 27-Apr-12 13:58pm

syed armaan hussain

Add a Solution

2 solutions

Solution 3

Hi Friend...

U can also try this

date1 = "23/03/1989"
date2 = "28/04/2012"

C#

ts = date2.Subtract(date1)  

iNumberOfDays = ts.Days  

strMsgText = "The total number of days elapsed since " _  
& date1.ToShortDateString() & " is: " & iNumberOfDays.ToString()

Posted 27-Apr-12 18:24pm

Arul R Ece

Updated 27-Apr-12 18:26pm

v4

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)

VJ Reddy · Accepted Answer · 2012-04-27T14:30:00

I think the method used is good.
Regarding Conversion of Date from string, if the Parse method is used then
Formatting is influenced by properties of the current DateTimeFormatInfo object, which by default are derived from the Regional and Language Options item in Control Panel. One reason the Parse method can unexpectedly throw FormatException is if the current DateTimeFormatInfo.DateSeparator and DateTimeFormatInfo.TimeSeparator properties are set to the same value. as explained here
http://msdn.microsoft.com/en-us/library/1k1skd40.aspx[^]

Hence, if the Format of date being displayed in the TextBox is fixed, let us say dd/MM/yyyy, then the ParseExact method explained here http://msdn.microsoft.com/en-us/library/w2sa9yss.aspx[^] where CultureInfo.InvariantCulture is recommended in the Note for custom format, may be better as shown below

C#

DateTime dt2 = DateTime.ParseExact("02/04/2012","dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);

Further these two statements

C#

int numberOfDays = ts.Days;
Label1.Text = numberOfDays.ToString();

can be combined as

C#

Label1.Text = ts.Days.ToString();

if there is no other purpose for numberOfDays.