vbGeneralDate - 3/11/2010 4:50:01 PM vbLongDate - Thursday, March 11, 2010 vbShortDate - 3/11/2010 vbLongTime - 4:50:01 PM vbShortTime - 16:50