topic Re: changing date format in Application Development and Automation Discussions

changing date format

Former Member — Mon, 04 Dec 2006 08:25:34 GMT

how will i change the date format from MM/DD/YYYY to DD.MM.YYYY in a ALV list.

Re: changing date format

Former Member — Mon, 04 Dec 2006 08:27:34 GMT

You can spcify the format you want in the EDIT_MASK of the field catalog for that field.

Regards,

Ravi

Note - Please mark all the helpful answers

Re: changing date format

amit_khare — Mon, 04 Dec 2006 08:28:28 GMT

Hi,

As an alternative you may use following code -

TYPES: BEGIN OF type_t_date,

mm(2) TYPE c,

filler1(1) TYPE c,

dd(2) TYPE c,

filler2(1) TYPE c,

yyyy(4) TYPE c,

END OF type_t_date.

DATA: t_ddate TYPE type_t_date.

CONSTANTS: c_fil TYPE c VALUE '.'.

t_ddate-mm = rs_sdate-mm.

t_ddate-dd = rs_sdate-dd.

t_ddate-yyyy = rs_sdate-yyyy.

t_ddate-filler1 = c_fil.

t_ddate-filler2 = c_fil.

CONCATENATE t_ddate-mm t_ddate-filler1 t_ddate-dd t_ddate-filler2 t_ddate-yyyy INTO rv_ddate.

Regards,

Amit

Re: changing date format

Former Member — Mon, 04 Dec 2006 08:28:45 GMT

Use EDIT_MASK.

Regards

Surya.

Re: changing date format

Former Member — Mon, 04 Dec 2006 08:28:46 GMT

To convert from YYYYMMDD to DD.MM.YYYY use the

FM<b> CONVERSION_EXIT_PDATE_OUTPUT</b>

Regards,

Santosh

Re: changing date format

Former Member — Mon, 04 Dec 2006 08:29:14 GMT

hi,

in field catalog u have edit_mask that should work.

santhosh

Re: changing date format

Former Member — Mon, 04 Dec 2006 08:29:50 GMT

write var 1 to var2 DD/MM/YYYY ,where var2 is of type c of length 10.

Perform the above and then pass the variable(Var2) instead of Var1 to the internal table which you pass to the FM or method for displaying the ALV list.

Regards

Mohamed Mansoor

Re: changing date format

Former Member — Mon, 04 Dec 2006 09:16:44 GMT

use offsets to do this

supposet the variable is w_var

then

w_var + 12/31/9999

concatenate w_var3(2) '.' w_var(2) '.' w_var6(4) into w_var1.

Your var1 will have 31.12.9999

Pass var1 to your ALV list.

I think this is what you need.

Reward if you find it helpful.

Prince menon

Re: changing date format

Former Member — Mon, 04 Dec 2006 10:12:59 GMT

use this

write SY-DATUM to variablename MM.DD.YYYY

u can change to any format dd.mm.yyyy,

dont forget to declare the variable as c, length 10.

I THINK IT WILL HELP U

Message was edited by:

Bharanidaran S

Message was edited by:

Bharanidaran S

Re: changing date format

Former Member — Mon, 04 Dec 2006 10:17:27 GMT

use edit-mask to get the required date format.

Regards

Haritha.