How can I use a range as a filter in cds views

[rajarshi_muhuri]

I want the abap cds view to filter (as parameters) on a range of dates. 

Example 

select * from table where dates between :p1 and :p2 ; 

how do I do this ? ( p1 and p2 are parameters ) 

[naveen_k1 · Accepted solution]

Hi, 

Try these steps-

• Define the CDS view with parameters for the date range.

        Example:

• Use the parameters in the WHERE clause to filter the data based on the date range.