Isdate returns true

[sandylou]

Hi i have a date I am trying to see if is valid 1/106


When I use isdate, it returns true. is there another easy way to check if this is valid other than breaking down the string into parts?

 

[Kliot]

I have to ask, what's wrong with January 106, it is a valid date. I guess the question is what do you consider a valid date?

You can use DateTime.ParseExact() but you will have to decide what a valid format is, in this example you will need to use a two digit month and two digit year for it to be valid.

Not a great solution but a solution none the less...

  Dim dt As DateTime
        Dim Culture = New CultureInfo("en-GB", True)

        Try
            dt = DateTime.ParseExact("01/106", "MM/yy", Culture, Globalization.DateTimeStyles.NoCurrentDateDefault)
            MessageBox.Show("Valid Date")
        Catch ex As Exception
            MessageBox.Show("Not a valid Date")
        End Try

 

[Sorwen]

My suggestion is to always force month, day, and year for dates. Either tacking it on when accepting the dates or just before you start working with the date.

-I hate Microsoft!
-Forever and always forward.
-My kingdom for a edit button!