Skip to Content
Dec 16, 2020 at 10:22 PM

Can we use substring function in CDS view where clause


My requirement is to fetch the current year by using the system date variable in the CDS view.

I am using the substring function along with $session.system_date field in the where clause but it is not allowing me to use it.

Can someone guide me on how to use it in the where clause?