Skip to Content

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

DAYSBETWEEN Input Parameters

Hi.

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.

Thanks.

Koos.

Former Member
Former Member replied

More info would be nice...here'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

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