topic Re: convert date on user specific settings in Application Development and Automation Discussions

convert date on user specific settings

tarangini_katta — Wed, 29 Jul 2009 12:26:28 GMT

Hi all,

I want to convert date on user specific settings

Example i have seetings like dd/mm/yy and another user has settings mm/dd/yyyy.

If i login any client i want to convert date to yyyyddmm.

How can i do this.

Thanks

Re: convert date on user specific settings

Former Member — Wed, 29 Jul 2009 12:27:38 GMT

Using T.Code SU01.

Regds,

Anil

Re: convert date on user specific settings

RaymondGiuseppi — Wed, 29 Jul 2009 12:43:03 GMT

- Use BAPI_USER_GET_DETAIL, returned parameter DEFAULTS-DATFM has the date format of the user.

- Table USR01 contains the same field

- Take a look at [SET COUNTRY|http://help.sap.com/abapdocu/en/ABAPSET_COUNTRY.htm]

- you can get the date format programmaticaly like in

 WRITE HIGH_DATE TO GDF_DATE DD/MM/YYYY.
  CASE GDF_DATE.
    WHEN '31.12.9999'. DATE_FORMAT = 1.
    WHEN '12/31/9999'. DATE_FORMAT = 2.
    WHEN '12-31-9999'. DATE_FORMAT = 2.
    WHEN '9999.12.31'. DATE_FORMAT = 4.
    WHEN '9999/12/31'. DATE_FORMAT = 4.
    WHEN '9999-12-31'. DATE_FORMAT = 4.
  ENDCASE.

For information on WRITE date format look at [WRITE Addition 14|http://help.sap.com/abapdocu/en/ABAPWRITE_TO_OPTIONS.htm#!ABAP_ADDITION_14@14@]

Regards,

Raymond

Re: convert date on user specific settings

Former Member — Wed, 29 Jul 2009 12:47:23 GMT

Hi,

DATA : L_DATE TYPE char10.

WRITE SY-DATUM to l_date. " Converts the sy-datum as per the user specific setting's and moves to l_date field

Re: convert date on user specific settings

Former Member — Wed, 29 Jul 2009 12:55:51 GMT

hi,

goto SU01. give the user name. click change.

goto DEFAULTS tab.

there you have date format.

select the format you want. then save.

job done.

thank you.

Somu

Re: convert date on user specific settings

Former Member — Wed, 29 Jul 2009 12:57:00 GMT

Hi,


*   Convert date 1/3/9999 into 99990301
    CALL FUNCTION 'CONVERSION_EXIT_SDATE_INPUT'
      EXPORTING
        input  = w_inputfile-endda
      IMPORTING
        output = w_inputfile-endda.

*   Convert date 99990301 into 01/03/9999
    CALL FUNCTION 'CONVERSION_EXIT_PDATE_OUTPUT'
      EXPORTING
        input  = w_inputfile-endda
      IMPORTING
        output = w_inputfile-endda.

or try this..



Key = sy-datum.

  SELECT SINGLE * FROM usr01 WHERE bname = sy-uname.
  CASE usr01-datfm.
    WHEN 1.
      WRITE key  TO formatted_date DDMMYY.
    WHEN 2 OR 3.
      WRITE key  TO formatted_date MMDDYY.
    WHEN OTHERS.
      WRITE key  TO formatted_date YYMMDD.
  ENDCASE.

Prabhudas

Re: convert date on user specific settings

Former Member — Wed, 29 Jul 2009 13:01:56 GMT

Hi,

Get the user specific setting using below FM:

SLS_MISC_GET_USER_DATE_FORMAT

Convert the date format into yyyy.mm.dd by using below FM (independent of user specific date):

SLS_MISC_CONVERT_TO_DATE

from here you can manipulate the date using concatenate.

Thanks and Regards,

Re: convert date on user specific settings

saranwin — Wed, 24 Jul 2013 18:31:47 GMT

Gr8.. It's works for me.. Thanks Avinash

Re: convert date on user specific settings

former_member777671 — Thu, 25 Jul 2013 05:28:15 GMT

Yes, this is the simplest solution