Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

DAYSBETWEEN Input Parameters


I have created 2 input parameters as type date for the start and end dates. I want to create a calculated column to calculate the days between the dates selected. I have done it on 2 separate ways but get different errors on both.

1st method: daysbetween('$$p_StartDate$$', '$$p_EndDate$$') goves error that my parameters are of type string, which it is not.

2nd method: daysbetween(daydate('$$p_StartDate$$'), daydate('$$p_EndDate$$')) - gives a Column Store error 6931 attribute is not a date or syntax error.

Could you please advice what I am doing wrong, we are on HANA rev 91.



Former Member
Former Member replied

More info would be's how. Also I could have give more instead of guiding line for misunderstanding Sorry. Lets do it with screenshots...Former Member example...

I have example Analytic view with 2 Imput parameters

Hana rev 95

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question