Extract month's Days during transformation

[hady_ibrahim]

Dear BW experts,

I want to extract days of month from 0CALDAY InfoObject

EX: 1,2,3,4,5,6,  ....31

Which routine Type is the best solution , Formula or Routine ?

when i create a formula  using Substring (0CALDAY,6 ,2) the result return correct day but with dots such as : . . 25

thanks in advance.

[hady_ibrahim · Accepted solution]

I have 0CALDAY InfoObject and i try to create routine it gives me error as this filed doesn't belong to source field. i create this formula and works fine SUBSTRING( CALDAY, 6, 2 ) where CALDAY is Characteristic  infoobject  with 2 CHAR length. thanks all so much

[Former Member]

Hi,

• create a new char with data type: numc like AM mentioed, but make sure you assing  length as :2 (ex: zcalday)
• add zcalday to target and map it with 0calday
• field routine -->result = source_fields-calday+6(2)

[former_member210321]

hi,

the infoobject should be type numc then through routine also you can obtain your requirement. for example:

result = <fieldname>+6(2).

AM