How to read the date format specified in the Regional Settings and change it ?

I need to ensure that the date format in Regional Settings is "dd/mm/yyyy". How do I find out the date format in Regional Settings and change it if necessary ?

LVL 1
rajesh_khaterAsked:
Who is Participating?
 
Leo EikelmanDirector, IT and Business DevelopmentCommented:
0
 
MilanKMCommented:
MsgBox Format(Date, "Short Date")
'Returns current system date in the system-defined short date format

MsgBox Format(Date, "Long Date")
'Returns current system date in the system-defined long date format

See the following link 2 set Regional Setting:~
http://www.tek-tips.com/viewthread.cfm?qid=1203846&page=1

:)
0
 
Kaleb2000acCommented:
Search for "Force Date Format" on this site, the solucion is a function that gets what you need.
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.