Knowledgebase
[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 3 pass-through queries and had them working to reference cells in for DateFrom and DateTo parameter. 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 make sure that you are passing both the dates (i.e. start date and end date) in the parameter value. There should be 12 months difference between two dates to get all the 12-month amount.

Also, Please make sure that you are passing the date in the correct format through the parameter.

Please use 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).