DEV Community

Wild Cat
Wild Cat

Posted on

Validate date format in VBA

#vba

Validate that the value is in the format "mm/dd/yyyy" 

Function ValidateDateFormat(dateValue As String) As Boolean

    If IsDate(dateValue) And Format(dateValue, "mm/dd/yyyy") = dateValue Then
            ValidateDateFormat = True
    End If

End Function
Enter fullscreen mode Exit fullscreen mode

Validate that the value is in the format "YYYYMMDD" 

Function ValidateDateFormat(dateValue As String) As Boolean

    If Len(dateValue) = 8 And IsDate(Format(dateValue, "@@@@/@@/@@")) Then
        ValidateDateFormat = True
    End If

End Function
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Read next

rehan111 profile image

The Power of Quora: A Platform for Knowledge Sharing and Growth

rehan khatri -

kellykenneth profile image

Exploring New Development Trends

Kelly Kenneth -

shafayeat profile image

Why Web Workers Depend on JavaScript ??

Shafayet Hossain -

msmith99994 profile image

Image vs WebP: Which Format Is Best and How to Convert Image to WebP

Michael Smith -