FoxMcCloud
FoxMcCloud

Reputation: 139

VB.NET - How do I find difference in dates in MM/DD format?

If I have two dates

Dim date1 As String = 01/05
Dim date2 As String = 01/07

Dim date As Integer

Date = 2

How do I go about making sure that 2 handles month changes and just general dates in this format?

Upvotes: 0

Views: 51

Answers (1)

Guffa
Guffa

Reputation: 700730

You would parse the strings into DateTime values, then you can subtract them to get a TimeSpan value that is the difference. Use the Days property to get the whole days from the value:

Dim date1 As String = "01/05"
Dim date2 As String = "01/07"

Dim d1 = DateTime.ParseExact(date1, "MM'/'dd", CultureInfo.InvariantCulture)
Dim d2 = DateTime.ParseExact(date2, "MM'/'dd", CultureInfo.InvariantCulture)

Dim date As Integer = (d2 - d1).Days

Upvotes: 3

Related Questions