Wild Cat Posted on Oct 20, 2024 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) Subscribe Personal Trusted User Create template Templates let you quickly answer FAQs or store snippets for re-use. Submit Preview Dismiss Code of Conduct • Report abuse Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink. Hide child comments as well Confirm For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)