topic Re: Substring in Abap Cds not working Properly in Application Development and Automation Discussions

Substring in Abap Cds not working Properly

Former Member — Tue, 29 May 2018 03:10:05 GMT

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

Re: Substring in Abap Cds not working Properly

retired_member — Tue, 29 May 2018 05:36:06 GMT

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

The function properly works as documented.

Re: Substring in Abap Cds not working Properly

Former Member — Tue, 29 May 2018 09:00:18 GMT

Hey Horst,

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

Regards,

Shawon

Re: Substring in Abap Cds not working Properly

gabriel_pill-kahan — Tue, 29 May 2018 18:02:57 GMT

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

Gabriel