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 query below 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?