Microsoft Excel: Date Filters and ${currdate} Macros

This will require Builder privileges for setup and implementation.

Issue:

At times a user will run into an issue when trying to use a macro for filtering the data coming from an Excel sheet.  When using the ${curr } macros Excel does not relate the data back to a proper Excel Date format and will give you an error.

An error occurred while retrieving the data for the
chart : [Microsoft][ODBC Excel Driver] Data type
mismatch in criteria expression..

The cause of this issue is the Microsoft Excel Driver handling of the data conversion.  

Resolution:

When adding your ${curr } macro to the filters add them like shown below, this will handle the conversion for you so that the issue does not come up.

DATEVALUE('${currdate}')

Once you change the macro type the integration between the Excel driver and iDashboards will work.

For More Information:

• iDashboards Builder Manual 10.5 Using Filters
• iDashboards Builder Manual 10.6 Using Filter Macros

If the above is unable to resolve the issue, then please contact iDashboards Support for further assistance.