Validate the date format

Question

I have a textbox in my form in vb 2010 which should accept only dates and only in the format of "yyyy/mm/dd"

How to achieve this? Please help

when i use date picker i am getting an error when i try to save the values into a database i get an error based on the format, i tried debugging that and dint work so i thought of using textbox but now i have to limit the textbox to accept only dates please help — user1795999, Mar 16 '13 at 18:46
Re: error saving to database. If you use SQL parameters to save to the database then you can send a DateTime instead of a String. This will eliminate the problem. — Andrew Morton, Mar 16 '13 at 20:13

score 1 · Accepted Answer · answered Mar 16 '13 at 19:00

Private Sub TextBox2_Validating(sender As System.Object, e As System.ComponentModel.CancelEventArgs) Handles TextBox2.Validating
    Dim test As Date
    If Date.TryParseExact(TextBox2.Text.ToString(), "yyyy/mm/dd", _
                          System.Globalization.CultureInfo.CurrentCulture, _
                          Globalization.DateTimeStyles.None, test) Then
        MessageBox.Show("Ok")
        'TODO: ok
    Else
        e.Cancel = True
        'TODO: not ok
    End If
End Sub

score 0 · Answer 2 · answered Mar 16 '13 at 19:00

0

If you use datepicker control then you can set to custom format as you like. In the form load event use below

DateTimePicker1.Format = DateTimePickerFormat.Custom
DateTimePicker1.CustomFormat = "yyyy/mm/dd"

Let me know if it helps.

answered Mar 16 '13 at 19:00

DevelopmentIsMyPassion

3,541
4
34
60

score 0 · Answer 3 · edited Jan 11 '15 at 15:23

0

You can try this:

DateTime.TryParseExact(dateToTest, "yyyy/MM/dd", New CultureInfo("us-US"), DateTimeStyles.None, result)

edited Jan 11 '15 at 15:23

Zach Saucier

24,871
12
85
147

answered Jan 08 '15 at 16:05

Pierre-Olivier Pignon

679
7
18

That does not answer the question: "should accept only dates and only in the format of "**yyyy/mm/dd**" – Leigh Jan 08 '15 at 16:31
you re right, it's because i m french, so i used french format. – Pierre-Olivier Pignon Jan 11 '15 at 14:20

Validate the date format

3 Answers3

Linked