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

