Skip to Content
0
Former Member
Apr 27, 2009 at 12:09 PM

Is it possible to change the way SAP stores a DATE field ?

46 Views

Hi,

I have a scenario here where I have to read from a file and then upload the contents to a custom table.

The file is comprised of several lines, each line being formatted to accomodate several fields, according to their length specifications. It's the "standard" string style to import/export files from one system to another.

My question is: one of these fields is a date field, and I am required to order the table, afterwards, by this date field. I notice it comes as DDMMYYYY, and my SORT is not working. If I use, on the other hand, dates in YYYYMMDD format, the SORT works perfectly.

Does SAP expects the date to come as YYYYMMDD ? Is there a way I can change this "default" format ?

Thanks,

Avraham