topic Re: regarding date and time format in Application Development and Automation Discussions

regarding date and time format

Former Member — Wed, 04 Mar 2009 11:02:47 GMT

Hi experts,

needed FM for date and time conversion.

Current: 20090304 005032

Required: 2/26/09 12:00 AM

thanks

manish

Re: regarding date and time format

Former Member — Wed, 04 Mar 2009 11:05:15 GMT

Hi,

/SDF/CMO_DATETIME_DIFFERENCE

Re: regarding date and time format

kamesh_g — Wed, 04 Mar 2009 11:05:18 GMT

Try with the following .

DATE_TIME_CONVERT

DATE_TO_PERIOD_CONVERT

Re: regarding date and time format

Former Member — Wed, 04 Mar 2009 11:06:18 GMT

Hi,

To convert the time format

Function module              HRVE_CONVERT_TIME
  Import parameters               Value

  TYPE_TIME                       A
  INPUT_TIME                      13:10:00
  INPUT_AM_PM                     AM


  Export parameters               Value

  OUTPUT_TIME                     01:10:00                 "  O_time
  OUTPUT_AM_PM                    PM                      " O_AMPM

For Date Simply WRITE sy-datum to l_Date. and concatenate l_date(5) O_AMPM Separated by space.

Edited by: Avinash Kodarapu on Mar 4, 2009 4:36 PM

Re: regarding date and time format

Former Member — Wed, 04 Mar 2009 11:08:48 GMT

Hi,

PERIOD_AND_DATE_CONVERT_INPUT

ABI_TIMESTAMP_CONVERT_FROM

reg,

vijay

Re: regarding date and time format

Former Member — Wed, 04 Mar 2009 11:13:54 GMT

Hi Manish,

Us the followinf function modules :

DATE_TIME_CONVERT

CONVERT_DATE_TO_INTERNAL

If you are using ALV report then their is a conversion exit SSLTS for this

Y_WA_FCAT-COL_POS = 7. " - DG1K902190

Y_WA_FCAT-COL_POS = 8. "+ DG1K902190

Y_WA_FCAT-TABNAME = 'T_FINAL'.

Y_WA_FCAT-FIELDNAME = 'CRTSP'.

Y_WA_FCAT-edit_mask = '==SLLTS'.

Y_WA_FCAT-SCRTEXT_L = 'PROD CREATED ON'.

Y_WA_FCAT-INTLEN = 20.

APPEND Y_WA_FCAT TO Y_I_FCAT.

CLEAR Y_WA_FCAT.

Can you let me know the Table name and filed name that you are using..so that i will be able to let you know the conversion exit, if there is anything available....

Regards,

Kittu