I have two datasets in a report, one is to Analysing Service cube and one is to a SQL db.
The dataset from the cube, I have a date parameter that is in text format and the value looks like this:
@ToDateDateValue = [Date].[DateValue].&[2011-07-14T00:00:00]
Now I want to use the same @ToDateDateValue in my SQL db query, but get the following error.
"Conversion Failed When converting date and / or time from character string."
How can I convert an MDX date to a date SQL db Query like? (DateTime 2011-07-14)