Skip to Content
avatar image
Former Member

Date conversion

Hi experts,

We are implementing BI 7.0.

We have BCT object 0ORGUNIT. Which is a time dependent data.

Our source data is 01.01.0001. But BI wont accept 0001.

it starts from 01.01.1000

i know With the help of transformation routine we can do date conversion.

How to write the exact code to convert the date in BI.

Please tell me exact sample code

Thanks, Srinivas

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 20, 2008 at 10:39 AM

    Hi,

    Here is the sample code.

    If SOURCE_FIELDS-xxxxxx(4) eq '0001'. "replace xxxxxx with field name

    CONCATENATE '1000' SOURCE_FIELDS-xxxxxx+4(4) INTO RESULT.

    endif.

    Hope this helps.

    Cheers

    Bala Koppuravuri

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 21, 2008 at 04:38 AM

    Thanks

    Add comment
    10|10000 characters needed characters exceeded