topic Re: Date in Application Development and Automation Discussions

Date

Former Member — Tue, 26 Feb 2008 06:41:06 GMT

How is the date stored in SAP?

YYYYMMDD or DDMMYYYY.

thanks in advance.

Former Member — Tue, 26 Feb 2008 06:43:35 GMT

hi,

YYYYMMDD only it stores.. if u go in debugging mode u can find that..

reward if useful

regards

karthik.T

Former Member — Tue, 26 Feb 2008 06:43:44 GMT

Hello Sreenivasa Moorthy,

In SAP, Date will get stored in the format of YYYYMMDD, but while displaying it will be like DDMMYYYY.

You can see the YYYYMMDD format while debugging a report.

Regards

Sasidhar Reddy Matli.

Former Member — Tue, 26 Feb 2008 06:45:00 GMT

Hi Srinivasa,

its YYYYMMDD format.

Thanks,

Swati

RemiKaimal — Tue, 26 Feb 2008 06:45:37 GMT

Hi,

In YYYYMMDD format

Use the FM : CONVERSION_EXIT_LDATE_OUTPUT to convert the date as desired

Usage:

DATA ldate(20).

CALL FUNCTION 'CONVERSION_EXIT_LDATE_OUTPUT'

EXPORTING

input = sy-datum

IMPORTING

OUTPUT = ldate.

Input : 20080208

output : 08.February2008

Cheers,

Remi

Former Member — Tue, 26 Feb 2008 06:47:01 GMT

Hi Srinivasa,

SAP stores date in the YYYYMMDD format. But this can be changed in the user masters record.

Edited by: p347633 on Feb 26, 2008 7:47 AM

Edited by: p347633 on Feb 26, 2008 7:48 AM