How to calculate day between two dates

Question

1.00/5 (1 vote)

See more:

Hi
I need to calculate between two date in asp.net text box.

mean 22.04.2018 12.00 pm to 23.04.2018 12.00 pm should be calculate = one day

Pls advice me

Maideen

What I have tried:

If True Then
    Dim dt1 As DateTime = Convert.ToDateTime(Me.txtDateFrom.Text)
    Dim dt2 As DateTime = Convert.ToDateTime(Me.txtDateTo.Text)
    Dim ts As TimeSpan = dt2.Subtract(dt1)
    If Convert.ToInt32(ts.Days) >= 0 Then
        Me.txtNoDays.Text = Convert.ToInt32(ts.Days) + 1
    ElseIf dt1 = dt2 Then
        Me.txtNoDays.Text = "Invalid Input"
    End If
End If

Posted 21-Apr-18 22:51pm

Maideen Abdul Kader

Updated 1-Aug-18 4:15am

RedDk

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)

OriginalGriff · Answer 1 · 2018-04-21T23:35:00

Take off the "+ 1" from the calculation...

But also, don't use Convert operations on user input: always use the appropriate TryParse (or TryParseExact) method instead. Users always type the wrong thing, and your app shouldn't crash as a result. Displaying an error message instead and giving them a change to fix the error is much more friendly!

Maciej Los · Answer 2 · 2018-04-23T01:18:00

In addition to solution #1 by OriginalGriff, check this:

VB.NET

Dim s1 = "22.04.2018 12.00 pm"
Dim s2 = "23.04.2018 12.00 pm"

Dim ci As Globalization.CultureInfo = Globalization.CultureInfo.InvariantCulture 
Dim fmt As String = "dd.MM.yyyy HH.mm tt"
Dim dt1 As DateTime = DateTime.Now
Dim dt2 As DateTime = DateTime.Now
Try
	dt1 = DateTime.ParseExact(s1, fmt, ci)
	dt2 = DateTime.ParseExact(s2, fmt, ci)
Catch Ex As Exception
	Console.WriteLine(Ex.Message)
End Try

Dim dayspassed As Integer = dt2.Subtract(dt1).Days
Console.WriteLine("Difference between '{0}' and '{1}' is: {2} day(s)", dt2.ToString("yyyy-MM-dd"), dt1.ToString("yyyy-MM-dd"), dayspassed)

For further details, please see:
How to: convert strings to DateTime | Microsoft Docs[^]
DateTime.ParseExact Method (String, String, IFormatProvider) (System)[^]
Performing arithmetic operations with dates and times | Microsoft Docs[^]

How to calculate day between two dates

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0