topic Re: How can I convert system date into user specified format? in Application Development and Automation Discussions

How can I convert system date into user specified format?

Former Member — Sat, 25 Aug 2012 06:28:06 GMT

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

Re: How can I convert system date into user specified format?

Former Member — Sat, 25 Aug 2012 07:05:50 GMT

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

Re: How can I convert system date into user specified format?

bharat_rathod2 — Sat, 25 Aug 2012 07:33:57 GMT

Dear,

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

Re: How can I convert system date into user specified format?

Former Member — Sat, 25 Aug 2012 08:20:49 GMT

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+date+format+to+Internal+format

Re: How can I convert system date into user specified format?

Former Member — Sat, 25 Aug 2012 09:04:08 GMT

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

Re: How can I convert system date into user specified format?

former_member189905 — Sat, 25 Aug 2012 10:03:34 GMT

Hi,

Can you try this and give me the result :

WRITE sy-datum TO gd_date USING EDIT MASK gd_format.

Khalid.

Re: How can I convert system date into user specified format?

bharat_rathod2 — Sat, 25 Aug 2012 10:12:01 GMT

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?

Re: How can I convert system date into user specified format?

Former Member — Tue, 28 Aug 2012 05:45:27 GMT

Hi,

check out the below thread

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

hope it helps!

Re: How can I convert system date into user specified format?

Former Member — Tue, 28 Aug 2012 13:45:37 GMT

Hi,

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

Manu.

Re: How can I convert system date into user specified format?

Former Member — Wed, 29 Aug 2012 05:55:55 GMT

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

Re: How can I convert system date into user specified format?

former_member215575 — Wed, 29 Aug 2012 06:48:09 GMT

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

Re: How can I convert system date into user specified format?

maxx — Tue, 08 Nov 2022 17:45:53 GMT

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