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.
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... example...
I have example Analytic view with 2 Imput parameters
Hana rev 95