07-20-2012, 12:36 PM
You can also try
Regards,
Ravi
Code:
MsgBox FormatDateTime(#2012-07-20#,vbShortDate)
'vbShortDate-Displays a date using the short date format specified in your computer's regional settings.
Regards,
Ravi