I'm attempting to load a file with the date on the file formatted as 04-NOV-13....I can't find a format that will accept the NOV...I've tried MTH, Mth and B..Anyone know what format to use to accept a 3 character, ALL CAP month format?
ie %d-%B-%d
%d-%MTH-%d
%d-%Mth-%d
Row 1: The string "04-NOV-13" could not be converted to a date from the format of %d-%Mth-%y
Loaded 0 rows into the database
Row 1: The string "04-NOV-13" could not be converted to a date from the format of %d-%MTH-%y
Loaded 0 rows into the database
Row 1: The string "04-NOV-13" could not be converted to a date from the format of %d-%B-%y
Loaded 0 rows into the database