cancel
Showing results for 
Search instead for 
Did you mean: 

How to convert yyyymm -mmyyyy format

Former Member
0 Kudos
344

Hi All,

How do I convert 0Fiscper format from yyyymm to mmyyyy in transformation rules

Thanks

Nau

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello,

Create routine:

Fiscper is usually in yyyymmm format...

CONCATENATE SOURCE_FIELDS-FISCPER5(2) SOURCE_FIELDS-FISCPER0(4) INTO RESULT.

Beware that calmonth is stored in yyyymm format.

BR

Ondrej

Edited by: Ondrej Vach on Mar 8, 2011 2:45 PM

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi, Firtsful you should create an infoobject with 6 characters. Then, you can do your work with formula or with routine as mentioned.

Former Member
0 Kudos

Hi

As Ondrej said you can use either routine or a formula

Thanks

Edited by: nittin abraham on Mar 4, 2011 8:36 PM