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.
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