• Home
 · 
• Miscellaneous
 · 
• Simply way to check the what is the date format in the Computer's Regional setting.

Simply way to check the what is the date format in the Computer's Regional setting.

Simply way to check the what is the date format in the Computer's Regional setting.

API Declarations


You can check the date format on the Regional setting and stop the project or continue



Rate Simply way to check the what is the date format in the Computer's Regional setting.

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

If Format$(38576, "Short Date") <> "2005/08/12" Then
    MsgBox "The Current date format is yyyy/MM/dd", vbExclamation
    End
End If
'--------------------------------------------------------------------
'To Check the Date format is DD/MM/YYYY
If Format$(38576, "Short Date") <> "12/08/2005" Then
    MsgBox "The Current date format is DD/MM/YYYY", vbExclamation
    End
End If
'--------------------------------------------------------------------
'To Check the Date format is MM/DD/YYYY
If Format$(38576, "Short Date") <> "08/12/2005" Then
    MsgBox "The Current date format is MM/DD/YYYY", vbExclamation
    End
End If
'--------------------------------------------------------------------