topic Re: Reg : Function Module in Application Development and Automation Discussions

Reg : Function Module

Former Member — Tue, 24 Jun 2008 05:45:28 GMT

Hi Friends,

Is tr any function module availble to convet the Date in DD-MM-YYYY format to system Date format(YYYYMMDD)?

Points will be rewarded for all helpful answer...

Re: Reg : Function Module

former_member206377 — Tue, 24 Jun 2008 05:48:02 GMT

Hi,

Use CONVERSION_EXIT_PDATE_INPUT

Regards,

Vasuki

Re: Reg : Function Module

Former Member — Tue, 24 Jun 2008 05:48:05 GMT

hi,

do this way ...You don't need any FM for that


concatenate v_date+6(4) v_date+3(2) v_date+0(2) into v_final.

Re: Reg : Function Module

Former Member — Tue, 24 Jun 2008 05:49:04 GMT

There is some extra support for this in patch 30 described in note 816761. Here is an excerpt:

New date format customizing options from NW04 SPS12 & EP6 SP2 Patch 30

Other terms

Reason and Prerequisites

NW04 SPS12 and EP6 SP2 Patch 30

Solution

There are new options to define how certain date formats (date,

timestamp and time properties) will be formatted.

The following keys can be configured in:

Configuration / Global Services / Property Metadata / Properties /

Additional Metadata

-Format

Use DateFormat defined patterns, DateFormat.SHORT, DateFormat.MEDIUM,

DateFormat.LONG.

Documentation:

http://java.sun.com/j2se/1.4.2/docs/api/java/text/DateFormat.html

as values: long/medium/short.

Example: format=long results in

Date type -> 17 January 2005

Timestamp -> 17 January 2005 16:09:23

Time -> 16:09:23

-customFormat

To set a customer pattern according to documentation:

http://java.sun.com/j2se/1.4.2/docs/api/java/text/SimpleDateFormat.html

If the pattern is not correct, the default date format will be used.

Example: customFormat=dd.MM.yyyy hh:mm:ss -> 17.01.2005 04:09:23

I hope this is helpful.

PS: Do award points.

Re: Reg : Function Module

Former Member — Tue, 24 Jun 2008 05:49:25 GMT

Hi ,

Use FM

CONVERT_DATE_TO_INTERNAL

Please reward if useful.

Re: Reg : Function Module

GauthamV — Tue, 24 Jun 2008 05:53:13 GMT

hi,

check this function module.

CONVERSION_EXIT_PDATE_INPUT

input : 01012008

output : 20080101

Re: Reg : Function Module

Former Member — Tue, 24 Jun 2008 05:57:17 GMT

Hi,

There are two function modules in which one converts to internal format and other converts to extranl format..

CONVERT_DATE_TO_EXTERNAL

CONVERT_DATA_TO_INTERNAL

check the function modules and it eases your problem.

Regards

Narin Nandivada.

Re: Reg : Function Module

Former Member — Tue, 24 Jun 2008 06:00:00 GMT

hi friends,

all the fm's r not working... see my input format is DD-MM-YYY

i need it as YYYYMMDD

Re: Reg : Function Module

former_member206377 — Tue, 24 Jun 2008 06:45:26 GMT

Hi Sasikanth,

Try this .

Parameter: in_date(10) type C.

Data : out_date(10) type C.

CALL FUNCTION 'CONVERSION_EXIT_PDATE_INPUT'

EXPORTING

input = in_date

IMPORTING

OUTPUT = out_date

write : out_date.

Reward if useful

Regards,

Vasuki

Re: Reg : Function Module

Former Member — Tue, 24 Jun 2008 07:07:31 GMT

Hi,

Either use FM or we can do it by coding.

CALL FUNCTION 'CONVERSION_EXIT_PDATE_INPUT'
  EXPORTING
    input            =  p_date
 IMPORTING
   OUTPUT        =  lv_date.

here p_date = 24-06-2008

lv_date = 20080624

By coding

CONCATENATE lv_date+6(4) lv_date
+3(2) lv_date+0(2) INTO lv_date1

This will surely help you.

Plz reward if useful.

Thanks,

Dhanashri.

Edited by: Dhanashri Pawar on Jun 24, 2008 9:08 AM