topic Re: date conversion in Application Development and Automation Discussions

date conversion

Former Member — Thu, 22 Nov 2007 08:09:40 GMT

Hi Abapers,

I need a FM which can convert date: YYYYMMDD to MM/DD/YYYY.

I have used the FM '/SAPDII/SPP05_CONVERT_DATE' to achieve this. but the problem is it doesnt handle exceptions. so it may lead to dump in some scenarios. kindly suggest me some Fm which can handle exceptions too.

Regards,

Radhika.

Re: date conversion

Former Member — Thu, 22 Nov 2007 08:12:30 GMT

Do like this

Data: Var1 type sy-datum,

var2(10) type c.

var1 = sy-datum.

Concatanate var14(2)'/' var16(2) '/' var1+0(4) into var2.

write var2.

Re: date conversion

Former Member — Thu, 22 Nov 2007 08:15:05 GMT

Hi Prem,

Do like this

YYYYMMDD to MM/DD/YYYY

Data: date1 type sy-datum,
         date2(10) type c.

Date1 = sy-datum. " This will be in YYYYMMDD format

Concatenate date1+4(2) date1+6(2) + date1+0(4) into date2 seperated by '/'.

write date2.

<b>Reward Points if this helps,</b>

Satish

Re: date conversion

Former Member — Thu, 22 Nov 2007 08:16:18 GMT

may this will help u..

data: gd_date(10). "field to store output date

Converts SAP date from 20020901 to 01.09.2002

write sy-datum to gd_date dd/mm/yyyy.

Converts SAP date from 20020901 to 01.09.02

write sy-datum to gd_date dd/mm/yy.

Prarthan

Re: date conversion

former_member386202 — Thu, 22 Nov 2007 08:27:19 GMT

Hi,

Try this FM

CALL FUNCTION 'CONVERT_DATE_TO_EXTERNAL'

EXPORTING

date_internal = lv_date

IMPORTING

date_external = lv_date1

EXCEPTIONS

date_internal_is_invalid = 1

OTHERS = 2.

IF sy-subrc <> 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF.

Regards,

Prashant

Re: date conversion

Former Member — Fri, 23 Nov 2007 13:27:23 GMT

to convert yyyymmdd to dd.mm.yyyy

data : wa1 type sy-datum,

wa2(10).

concatenate wa1+6(2)'.'

wa1+4(2)'.'

wa1(4) into wa2.