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

changing the date format

Former Member — Mon, 18 Jun 2007 05:48:13 GMT

How do i create a function module that imports date in a system format and displays the output in the following format:

Input date : 12/31/9999

Output date: 31st December 9999

Re: changing the date format

Former Member — Mon, 18 Jun 2007 05:50:51 GMT

Hi,

Try this,

Use FM ISP_GET_MONTH_NAME and the values to it like this and use concatanate to the same

Import parameters Value

DATE 20.02.2007

LANGUAGE EN

MONTH_NUMBER 00

Export parameters Value

LANGU_BACK EN

LONGTEXT February

SHORTTEXT FEB

Thanks.

Re: changing the date format

Former Member — Mon, 18 Jun 2007 05:52:56 GMT

Hi,

date3 EQ 'X'. "The date format is like 31 apr, 2007

CONDENSE temp_date NO-GAPS.

SPLIT i_date AT ',' INTO daymonth year.

IF STRLEN( year ) NE '4'.

error = 'X'.

WRITE : 'Invalid date format.'.

ELSE.

daymonth1 = daymonth.

CONDENSE daymonth1 NO-GAPS.

SHIFT daymonth1 LEFT BY 2 PLACES.

CONDENSE daymonth1 NO-GAPS.

month = daymonth1.

CONDENSE month NO-GAPS.

TRANSLATE month TO UPPER CASE.

SORT t_month BY monthstx.

MOVE month to mon.

READ TABLE t_month WITH KEY monthstx = mon.

IF sy-subrc <> 0.

error = 'X'.

WRITE : 'Invalid date format.' .

ELSE.

CONDENSE daymonth NO-GAPS.

day = daymonth+0(2).

CONDENSE day NO-GAPS.

CONCATENATE year t_month-monthnumber day INTO o_date.

ENDIF.

<b>Reward points</b>

Regards

Re: changing the date format

Former Member — Mon, 18 Jun 2007 06:04:59 GMT

Hi,

You may use FM DAY_ATTRIBUTES_GET with input date in dd.mm.yyyy format.

So you first need to convert the date from mm/dd/yyy to format dd.mm.yyyy by using the string operations & then use the above mentioned FM.

I hope this helps,

Regards,

Raju Chitale