How can I convert system date into user specified format?

[Former Member]

Hi Experts...

   I have a requirement to get the current date in user specified format.

I am using function module which will return the user specific date format (DATFM) and that I am storing into a variable.

Now I need to convert current date into that particular format.

suppose gd_format will store the user spcific date format.

I used the following code to convert the system date into that format.

WRITE: sy-datum USEING EDIT MASK gd_format TO gd_date.

But it will store the format itself into gd_date insted of the date.

Eg: If gd_format is DD.MM.YYYY and sy-datum is 20120824

After using the Write statement

The value in gd_date is DD.MM.YYYY.

I want date in gd_date as per the user specified format. That can be different for different users.

Kindly help me..

Thanks

Pradeep

[Former Member]

Hi Experts...

   I have a requirement to get the current date in user specified format.

I am using function module which will return the user specific date format (DATFM) and that I am storing into a variable.

Now I need to convert current date into that particular format.

suppose gd_format will store the user spcific date format.

I used the following code to convert the system date into that format.

WRITE: sy-datum USEING EDIT MASK gd_format TO gd_date.

But it will store the format itself into gd_date insted of the date.

Eg: If gd_format is DD.MM.YYYY and sy-datum is 20120824

After using the Write statement

The value in gd_date is DD.MM.YYYY.

I want date in gd_date as per the user specified format. That can be different for different users.

Kindly help me..

Thanks

Pradeep

[Former Member]

hi pradeep,

please try this,

date1 = sy-datum.

time = sy-timlo.

WRITE date1 USING EDIT MASK '____/__/__' TO lv1.

WRITE time USING EDIT MASK '__:__:__' TO lv2.

write 😕  lv1 DD/MM/YYYY.

use underscor instead of DD MM YYYY

thanks,

marimuthu.k

[bharat_rathod2]

Dear,

please tell me how you can identify which user want which format?

[Former Member]

Have a look at this Link.Maybe this might provide you with the solution that you want.Please give Points if link was found useful.

http://wiki.sdn.sap.com/wiki/display/Snippets/ABAP+-+Function+module+for+converting+any+External+dat...

[Former Member]

hi pradeep,

please try the following,

DATA : date1 TYPE char8,
time  TYPE char6,
var10 TYPE char10,
var8  TYPE char8,
lv_length TYPE i,
li        TYPE i,
lv_off    TYPE i,
z TYPE char2.
PARAMETER lv TYPE char10.
date1 = sy-datum.
time = sy-timlo.
FIELD-SYMBOLS <f> TYPE char10.
ASSIGN lv TO <f>.
<f> = lv.

FIND ALL OCCURRENCES OF 'DD'  IN  <f> MATCH LENGTH lv_length MATCH OFFSET lv_off.
var10+lv_off(lv_length) = date1+6(2).
li = lv_off + lv_length.
IF li <> 10.
   lv_off = li.
   var10+lv_off(1) = '/'.
ENDIF.

FIND ALL OCCURRENCES OF 'MM'  IN  <f> MATCH LENGTH lv_length MATCH OFFSET lv_off.
var10+lv_off(lv_length) = date1+4(2).
li = lv_off + lv_length.
IF li <> 10.
   lv_off = li.
   var10+lv_off(1) = '/'.
ENDIF.

FIND ALL OCCURRENCES OF 'YYYY'  IN  <f> MATCH LENGTH lv_length MATCH OFFSET lv_off.
var10+lv_off(lv_length) = date1+0(4).
li = lv_off + lv_length.
IF li <> 10.
   lv_off = li.
   var10+lv_off(1) = '/'.
ENDIF.

WRITE: date1,var10.

if u give input DD/mm/yyyy like this u ll get o/p as 25/08/2012.

in ur case instead of lv pass gd_date u will get desired o/p.

reward points if it is useful.

thanks,

marimuthu.k

[former_member189905]

Hi,

Can you try this and give me the result :

WRITE sy-datum TO gd_date USING EDIT MASK gd_format.

Khalid.

[bharat_rathod2]

Dear first give me answer

where you define that which user want which formt?

means user and format combination is fixed or not?

if fix then where it is?

if not then how you get the format for user?

[Former Member]

Hi,

check out the below thread

http://scn.sap.com/thread/837696

hope it helps!

[Former Member]

Hi,

You just need to call the FM CONVERT_DATE_TO_EXTERNAL, which take the user format into account...

Manu.

[Former Member]

Use FM   FORMAT_DATE_4_OUTPUT

For ex,

              CALL FUNCTION 'FORMAT_DATE_4_OUTPUT'
              EXPORTING
                datin  = sy-datum
                format = 'DD.MM.YYYY'
              IMPORTING
                datex  = result.

you can pass format in export parameter 'format'.

Regards.

Kaushik Savaliya

[former_member215575]

Hi Pradeep,

Use FM SLS_MISC_CONVERT_TO_DATE to convert date sy-datum format to user default format.

Hi Bharat,

User format is defaulted in (Menu option:System-->User Profile-->Own data) or can also be found in USR01 table. Check DATFM field passing BNAME. Use domain value range of DATFM to indentify what format is set for the user.

Regards,

Sravan Guduru

[maxx]

data(today) = |{ sy-datum DATE = USER }|. "ABAP 7.4+