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?

[Webinar] Streamline your web hosting managementRegister Today

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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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
All Courses

From novice to tech pro — start learning today.