Date format mmyyyy

[Former Member]

hi,

I am writing a routine in BW.I am loading data from a flat file.

i have selected date format like 0calmonth.the format is yyyymm.

I want to change it to mmyyyy.how can i write a formula in routine'?

how can i do that?

Thanks in advance,

Yad

[Former Member]

Hi,

let field date conytains your original date :

Data : date1(6),

concatenate date+4(2) date(4) into date1.

date = date1.

regards,

Gagan

[RichHeilman]

Here is a quick way....

  data: mmyyyy(6) type c ,
        yyyymm(6) type c value '200506'.


        mmyyyy+0(2) = yyyymm+4(2).
        mmyyyy+2(4) = yyyymm+0(4).

        check sy-subrc = 0.

Regards,

Rich Heilman