All Constants Color Constants Comparison Constants Date and Time Constants Drive Object FileAttribute Property File Input/Output Constants MsgBox Constants String Constants Tristate Constants VarType Constants CONSTANTS:  Date Format Implemented in version 2.0   Date Format Constants   You may use either the CONSTANT (left column) or the VALUE (center column) in your code and get the same results.   CONSTANT VALUE DESCRIPTION VBGeneralDate 0 Display the date and time using system settings VBLongDate 1 Display the date in long date format June 26, 1943 VBShortDate 2 Display the date in short date format 6/26/43 VBLongTime 3 Display the time in long time format 3:48:01 PM VBShortTime 4 Display the time in short time format (24 hour clock) 15:48