KB47008: Users attempting to utilize the Date function with a Denodo database in MicroStrategy 9.4.1 may notice incorrect SQL being generated in the report SQL.

SYMPTOM:
Users with a Denodo database set up may notice incorrect SQL is being generated in objects the utilize the Strategy Date function.
 
Note the wrong format in the To_Date function: 

"...and a11.`month_year` >=  TO_DATE('MM/DD/YYYY HH:MM:SS','03/17/2013 00:00:00'))"

 
Here is what the formatting should look like:

"...and a11.`month_year` >=  TO_DATE('MM/dd/yyyy HH:mm:ss','03/17/2013 11:48:00')"

 
CAUSE:
This is a known issue in Strategy 9.4.1
 
ACTION:
This issue has been addressed in Strategy 10. Upgrade to take advantage of the fix.