date validations in dd/mmm/yy format

Hi,

I want to validate the date entered in a text box to be in the form of dd/mmm/yy for example the date entered should be 16/jan/04. i want to validate this text in the text box. Any ideas.....

Any suggesstions will be appreciated

regards,
-Kedar
kedarpdAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Farzad AkbarnejadConnect With a Mentor DeveloperCommented:

' Returns True if inpDate as string representation of date like
' 16/jan/04 is a valid date. Only workd with dd/mmm/yy format.
Public Function DateIsValid(inpDate As String) As Boolean
    On Error GoTo Err_Handling_DateIsValid

    Dim testVar As Date
    inpDate = Left(inpDate, Len(inpDate) - 2) & "20" & Right(inpDate, 2)
    DateIsValid = True
    testVar = CDate(inpDate)

    Exit Function
Err_Handling_DateIsValid:
    If Err.Number = 13 Then
        DateIsValid = False
    End If
End Function


-FA
0
 
Farzad AkbarnejadDeveloperCommented:
Hi,
if you are programming Visual Basic you can use the following function:


' Returns True if inpDate as string representation of date like
' 16/jan/2004 is a valid date.
Public Function DateIsValid(inpDate As String) As Boolean
    On Error GoTo Err_Handling_DateIsValid

    Dim testVar As Date
   
    DateIsValid = True
    testVar = CDate(inpDate)

    Exit Function
Err_Handling_DateIsValid:
    If Err.Number = 13 Then
        DateIsValid = False
    End If
End Function


-FA
0
 
lttia1Commented:
hi,

How about making a switch to DateTimePicker control. You can custom the control to dd/mmm/yy format.
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
bhagyeshtCommented:
best would be to use a masked edit box it takes care of this validation by the format
Bhagyesh Trivedi
0
 
kedarpdAuthor Commented:
Hi Bhagyesh Trivedi,

Thnx for ur suggestions...

Masked edit box takes care only of the format but does not validate the entry. For example if i give the mask as ##/???/## It does take care of te format but if i enter 99/kkk/88 , then it only validates the format and not the text. i want to also validate the text as month cannot be kkk or date cannot be  99 etc.

any ideas ......


Regards

Kedar
0
 
lttia1Commented:
You are using which version of vb?
0
 
kedarpdAuthor Commented:
Hi lttia1,

i am using Visual Basic 6.0 (sp5) on win 2k platform
0
 
Farzad AkbarnejadDeveloperCommented:
Try the function I posted at first. ;)

-FA
0
 
lttia1Commented:
In that case, why don't you consider using DateTimePicker control. You can custom the control to dd/mmm/yy format and no validation has to be done.
It appears in the form of combo box but when you drop down. it is actually a calendar.
0
 
kedarpdAuthor Commented:
Hi  FarzadA,

Ur function is good but it doesn't validate for the date part. for exapmle if i give 44/jan/02 it returns true.

Kedar
0
 
Farzad AkbarnejadDeveloperCommented:
Because 44/jan/02 means 2-Jan-1944. If you use 44/jan/2002 it returns false.
Is year is right most digits? Or input date is ##/###/## format? I can modify this function.

-FA
0
 
kedarpdAuthor Commented:
Hi FarzadA


input date is of format 12/jan/02.
ie ##/???/## wher #-represents numbers
?- represents characters

Kedar
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.