Date FORMAT ISSUE

Previous topic - Next topic

DDP021

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

kasim

#1
try %d-%b-%y

%B is for long style of month e.g. November

u have to add this format in windows registry also.

DDP021

Here is the format that worked....

%e-%b-%y

Not sure what the %d didn't work for the day.....

rick

%d would have expected 1 instad of 01