Check for date format

[Lhuffst]

How would you check to make sure that a field is formatted correctly? I have a textbox that has a date. The format of the textbox is 'mm/dd/yyyy' and throughout the code it is set up as format(txtdateassigned,"mm/dd/yyyy") but in one instance it is passing the time not the actual date. This is obviously causing problems. How do I code the if statment to make sure that it is a valid date?
Thanks
lhuffst

 

[Ed2020]

Something like:

If Not IsDate(txtDateAssigned) Then
    MsgBox "This is not a date."
Else
    'Run your code.
End If

Ed Metcalfe.

Please do not feed the trolls.....

 

[PHV]

Ed, a time IS a date ...

 

[Ed2020]

Ah, yes. Good point!

Time for a rethink....

Ed Metcalfe.

Please do not feed the trolls.....

 

[Ed2020]

Does this do what you want?

If Not IsDate(txtDateAssigned) And DateValue(txtDateAssigned)<>"00:00:00" Then
    MsgBox "This is not a date."
Else
    'Run your code.
End If

Ed Metcalfe.

Please do not feed the trolls.....

 

[Lhuffst]

Thanks. It looks like that will do it.