Substring in Abap Cds not working Properly

[Former Member]

Hi Team,

I am trying to calculate the number of working days remaining in a month. Suppose you are passing 2018-02-20 as a prompt. So it should give me the remaining number of working days coming from Tfacs table in that month.

capture.png

But the substring function is not considering StartDay which is an integer value.

The error is given below.

"Function SUBSTRING: at position 2, only Literals, possibly positive integers allowed"

If I use a hard coded number in place of StartDay, it works fine.

Please help me on this.

Regards,

Shawon

[Former Member]

Hi Team,

I am trying to calculate the number of working days remaining in a month. Suppose you are passing 2018-02-20 as a prompt. So it should give me the remaining number of working days coming from Tfacs table in that month.

capture.png

But the substring function is not considering StartDay which is an integer value.

The error is given below.

"Function SUBSTRING: at position 2, only Literals, possibly positive integers allowed"

If I use a hard coded number in place of StartDay, it works fine.

Please help me on this.

Regards,

Shawon

[retired_member]

Did you bother to read the syntax error or the documentation?

The function properly works as documented.

[Former Member]

Hey Horst,

Yes I did. I was looking for a workaround to do this.

Regards,

Shawon

[gabriel_pill-kahan]

I'm curious - are you able to use standard function module DATE_CONVERT_TO_FACTORYDATE? Please see documentation.

Gabriel