topic Re: Convert Date in Application Development and Automation Discussions

Convert Date

Former Member — Wed, 24 May 2006 14:32:11 GMT

Hi,

I have a date just with month and year. like this:

032006

what i want is to know if there is any function that inverts my date to stay like this:

200603

thanks,

ricardo

Re: Convert Date

Former Member — Wed, 24 May 2006 14:33:29 GMT

data: date1(6) value '032006',

new_date(6).

concatenate date12(4) date10(2) into new_date.

write:/ new_date.

Regards,

Ravi

Re: Convert Date

Former Member — Wed, 24 May 2006 14:35:46 GMT

Hi,

I don't think there is any FM which converts that way. Use Concatenate Statement or Offset to achieve the same. Any wayz Try Using CONVERSION_EXIT_PDATE_INPUT

Re: Convert Date

Former Member — Wed, 24 May 2006 14:35:49 GMT

data : var(6).

var = date+2(4)

var+4(2) = date(2)

Re: Convert Date

Former Member — Wed, 24 May 2006 14:35:54 GMT

Hi,

Use offset.

say, var1 = '062003'.

var2 = var1+0(2).

var3 = var1+2(4).

concatenate var3 var2 into var1.

Thanks,

Aswin

Re: Convert Date

Former Member — Wed, 24 May 2006 14:38:03 GMT

Hi ricardo,

concatenate date2(4) date0(2) into date.

regards,

keerthi.

Message was edited by: keerthi kiran varanasi

Re: Convert Date

Former Member — Wed, 24 May 2006 14:38:06 GMT

hii

use this fm

CONVERSION_EXIT_PDATE_INPUT

CALL FUNCTION 'CONVERSION_EXIT_PDATE_INPUT'

EXPORTING

INPUT = p_date

IMPORTING

OUTPUT = v_date

using offset of p_date .

Regards

Naresh

Re: Convert Date

RichHeilman — Wed, 24 May 2006 14:41:45 GMT

Yes, there is a function module. Check this conversion exit.



report zrich_0001.


data: input(6) type c value '032006'.
data: output(6) type c.

call function 'CONVERSION_EXIT_PERI_INPUT'
  exporting
    input            = input
*   NO_MESSAGE       =
 importing
   output           = output
*   RETURN           =
          .

write:/ output.

This is the standard conversion exit which is tied to the data element SPBUP which is a 6 character numeric field which is for posting period(YYYYMM)

Regards,

Rich Heilman