Solved

VB.NET Calculate Date Difference

Posted on 2008-10-10
9
3,485 Views
Last Modified: 2012-05-05
I know there must be an easier way to calculate difference between dates or if one date is less than another.  Problem is I am trying to calculate a date in at text box against Date.Now.

This does not work.  
If CDate(Me.TextBox1.Text) < Date.Now Then
  MessageBox.Show("Date is less than" & Date.Now, "Date", MessageBoxButtons.OK, MessageBoxIcon.Information)
End If

This also does not work.  
Dim strDateDiff As String = DateDiff(DateInterval.Day.ToString(), Me.TextBox1.Text, Date.Now)

Any ideas?
0
Comment
Question by:CipherIS
9 Comments
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 22686457
Hi CipherIS,

Use the DateTime.Compare method -> http://msdn.microsoft.com/en-us/library/system.datetime.compare(VS.80).aspx

        If Date.Compare(CDate(Me.TextBox1.Text), Date.Now) < 0 Then
            MessageBox.Show("Date is less than" & Date.Now, "Date", MessageBoxButtons.OK, MessageBoxIcon.Information)
        End If

Regards,

Wayne
0
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 22686474
I'd also be interested to know what you mean by "does not work". Is it producing any errors, or does it return unexpected results?

Wayne
0
 
LVL 1

Author Comment

by:CipherIS
ID: 22686508
It does not compare correctly so it always displays the message box.
0
 
LVL 8

Expert Comment

by:tiagosalgado
ID: 22686546
Try to watch your date values and check if they are in same format. Maybe there is your problem.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 1

Author Comment

by:CipherIS
ID: 22686562
Still does not worked.  Attached file.
Date.JPG
0
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 22686583
CipherIS,

If the textbox has todays date in it, it will always be less than Date.Now, because it also takes the time into account.

Wayne
0
 
LVL 48

Accepted Solution

by:
jpaulino earned 500 total points
ID: 22686680
Try this method substracting the dates:
        Dim dt As New DateTime
 

        ' checks if it's a valid date

        If DateTime.TryParse(Me.TextBox1.Text, dt) Then
 

            ' Get's the number of days

            Dim days As Integer = dt.Subtract(Now.Date).TotalDays
 

            ' Writes the result

            Select Case days

                Case 0

                    Debug.WriteLine("TextBox1 = Now")

                Case Is > 0

                    Debug.WriteLine(String.Format("TextBox1 > Now in {0} days", days.ToString))

                Case Is < 0

                    Debug.WriteLine(String.Format("TextBox1 < Now in {0} days", days.ToString))

            End Select
 

        End If

Open in new window

0
 
LVL 1

Author Closing Comment

by:CipherIS
ID: 31504992
Works as expected
0
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 22686812
CipherIS,

I'm curious why you selected jpaulino's suggestion over mine? I mentioned the reason why it was saying it was less than Date.Now at http:#a22686583

Wayne
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now