Knowledgebase: Sp_commands & Reports
[QODBC-Desktop] Troubleshooting - Excel only returning Amount_1 and not Amount_1 through Amount_12.
Posted by Jack - QODBC Support on 22 January 2018 09:22 AM

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

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).