Troubleshooting - Excel only returning Amount_1 and not Amount_1 through Amount_12.

Problem Description:

I am working in Excel. I have set up three pass-through queries and had them work on referencing cells for DateFrom and DateTo parameters. The queries were SummarizeColumnsBy by Month.

The queries suddenly stopped working, only returning Amount_1 and not Amount_1 through Amount_12.

If I manually put the date in the command text, all 12 months will return.

Solution:

Please ensure that you pass both the dates (i.e., start date and end date) in the parameter value. There should be 12 months difference between the two dates to get all the 12-month amount.

Also, please ensure that you pass the date in the correct format through the parameter.

Please use the below format & check again:

YYYY-MM-DD

For Example:

DateFrom: 2017-01-01

DateTo: 2017-12-31