Date conversion

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

Thanks