topic Re: Can we use substring function in CDS view where clause in Application Development and Automation Discussions

Can we use substring function in CDS view where clause

Husain — Wed, 16 Dec 2020 22:22:19 GMT

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?

former_member689077 — Thu, 17 Dec 2020 03:38:07 GMT

Hi husainsd

please check below code you can able to understand,

define view ZK_I_DATE_FUNC as select from ZK_I_DATE_FUNCTIONS

{

Id,

Name,

StartDate,

EndDate,

//date functions

DATs_is_valid(StartDate) as s_Date1,

dats_is_valid(EndDate) as e_Date1,

dats_days_between(StartDate, EndDate) as betweenS,

dats_add_days(StartDate, 7, 'NULL') as ad_days,

dats_add_months(StartDate, 2, 'FAIL') as ADD_MONTHS,

DATS_ADD_DAYS(StartDate, 4, 'INITIAL') as option4,

DATS_ADD_DAYS(StartDate, 2, 'UNCHANGED') as option5

} where StartDate = $session.system_date

Husain — Thu, 17 Dec 2020 17:44:57 GMT

Hi Kiran,

I need to extract the current year from the system.date. In the where clause something like

year= system.date+4?

Can we do this?