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 similar to below.

Example Error:

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

CAUSE:

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}')


All you will need to change is the macro type, and the integration between the Excel driver and iDashboards will work smooth.