Date filter not working

Hello Helical Insight,
We are using Helical Insight Enterprise Edition 4.0 GA. We created a report using which has date pickers. However, at the dashboard, the date filters is showing NaN. Why so?

Thank You,
Sesa.

Hello Sesa,

there can be multiple reasons. But in your case, as we troubleshooted, it is happening because you kept the name of the filters as “Date” which is a reserved keyword.

image

please do not use reserved keywords. “Date” is a reserved keyword in javascript and java and sql. Similarly there are other multiple reserved keywords like Date, Time, Subject, Int etc. Do not keep filter names or alias names or dashboardvariables etc as reseved keywords.

At the report level we have changed the filtername as “Date1” instead of date.

Thank You,
Helical Insight.