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
try %d-%b-%y
%B is for long style of month e.g. November
u have to add this format in windows registry also.
Here is the format that worked....
%e-%b-%y
Not sure what the %d didn't work for the day.....
%d would have expected 1 instad of 01