topic Re: Date format in Application Development and Automation Discussions

Date format

Former Member — Mon, 19 Mar 2007 16:55:11 GMT

Hi,

Is there any FM for changing date format?

Ex: input date: 20080318 ( today)

output is: March 18, 2008.

is there any FM's?

Thanx

Giri

Re: Date format

Former Member — Mon, 19 Mar 2007 17:03:58 GMT

Hi,

Check this..

DATA: V_INPUT(8) VALUE '20112006'.

DATA: V_CHAR(25).

data: date type sydatum.

DATA: MONTH_NAMES LIKE T247.

SELECT SINGLE * FROM T247

INTO MONTH_NAMES

WHERE SPRAS = SY-LANGU

AND MNR = V_INPUT+2(2).

CONCATENATE MONTH_NAMES-KTX V_INPUT(2) V_INPUT+4(4)

INTO V_CHAR SEPARATED BY SPACE.

write: / V_CHAR.

Thanks,

Naren

Re: Date format

Former Member — Mon, 19 Mar 2007 17:14:54 GMT

Hi Giri,

Try this FM " CONVERT_DATE_TO_ALPHA_NUMERIC". Its not exactly the way you want but...

Let me know if you have further questions..

Rakesh

Re: Date format

Former Member — Mon, 19 Mar 2007 17:18:44 GMT

Hi,

Please check this FM HR_IN_GET_DATE_COMPONENTS.


DATA: L_DAY(2)   TYPE C,
      L_MONTH(2) TYPE C,
      L_YEAR(4)  TYPE C,
      L_LTEXT    TYPE T247-LTX.
                                                                        
DATA: L_DATE TYPE STRING.
                                                                        
CALL FUNCTION 'HR_IN_GET_DATE_COMPONENTS'
  EXPORTING
    IDATE                         = SY-DATUM
  IMPORTING
    DAY                           = L_DAY
    MONTH                         = L_MONTH
    YEAR                          = L_YEAR
    LTEXT                         = L_LTEXT
  EXCEPTIONS
    INPUT_DATE_IS_INITIAL         = 1
    TEXT_FOR_MONTH_NOT_MAINTAINED = 2
    OTHERS                        = 3.
                                                                        
CONCATENATE L_LTEXT ',' INTO L_DATE.
CONCATENATE L_DATE L_DAY L_YEAR INTO L_DATE SEPARATED BY SPACE.

WRITE: L_DATE.

Regards,

Ferry Lianto

Re: Date format

Former Member — Mon, 19 Mar 2007 17:39:01 GMT

HI Naren,

it is getting only Aug or Oct instead of August or october.

Thanx

Giri

Re: Date format

Former Member — Mon, 19 Mar 2007 17:40:09 GMT

HI rakesh,

that FM is not available.

i tried with CONVERT_DATE_TO_INTERN_FORMAT but i dont know what to fill in DTYPE parameter.

Thanx

Giri

Re: Date format

amit_khare — Mon, 19 Mar 2007 18:05:50 GMT

It will give the long month change KTX to t247-ltx in the select statement.

select single * from t247 where spras = sy-langu

and mnr = month_number.

shorttext = t247-ktx.

longtext = t247-ltx.

langu_back = t247-spras.

Regards,

Amit

Reward all helpful replies.

Re: Date format

Former Member — Mon, 19 Mar 2007 18:08:46 GMT

Hi,

Instead of KTX use LTX..

DATA: V_INPUT(8) VALUE '20112006'.

DATA: V_CHAR(25).

data: date type sydatum.

DATA: MONTH_NAMES LIKE T247.

SELECT SINGLE * FROM T247

INTO MONTH_NAMES

WHERE SPRAS = SY-LANGU

AND MNR = V_INPUT+2(2).

CONCATENATE MONTH_NAMES-<b>LTX</b> V_INPUT(2) V_INPUT+4(4)

INTO V_CHAR SEPARATED BY SPACE.

write: / V_CHAR.

Thanks,

Naren

Re: Date format

Former Member — Mon, 19 Mar 2007 18:16:14 GMT

HI,

Thanx for all of u...

Naren and Ferry both ur answers are worked...

Thanx once again..

Can anybody help me in my other question BAPI_BUS1077_CREATE in other thread?

Thanx

Giri