Knowledgebase: Tutorials
[QODBC-Desktop] Troubleshooting - How can I Get all the Records for a specified Year
Posted by Jack - QODBC Support on 09 March 2016 12:48 PM

Troubleshooting - How can I Get all the Records for a specified Year

Problem Description:

I need to compute a Year to Date total paid using the Invoice table. I'm working in MS-Access and need to run the following statement:

SELECT SUM(Subtotal) FROM Invoice WHERE CustomerRefListID = 'some customer ID' AND IsPaid AND TimeCreated BETWEEN date1 AND date2 
 

Solution:

You can use the below query to get details about records for a specified Year.

For Example:

Select * from Invoice where {fn YEAR(TxnDate)} = 2017

For more details, Refer to: How are dates formatted in SQL queries when using the QuickBooks generated timestamps?

(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).