Skip to Content
0
Jan 12, 2023 at 11:31 AM

I am getting an format error i BW4HANA transformation rule for Workdays_between

70 Views Last edit Jan 13, 2023 at 07:11 AM 2 rev

I am trying to use the standard formula inside BW Transformation formula WORKDAYS_BETWEEN (HANA Runtime), but i am get a format error when trying to activate. Dos anyone else use the predefine formula ?

Example of Formular

BW Formular : WORKDAYS_BETWEEN ( '01'; TO_DATE('20221224'); TO_DATE('20221227'); 'SAPXXX')

SQL example is working fine in HANA SQL

Select workdays_Between('01', '2022-12-24', '2022-12-27', 'SAPXXX') "workdays" from dummy