PQ: query to select rows from 2016

[SallyG]

Good afternoon,
This is a beginner's post: how do I modify
"= Odbc.Query("dsn=QuickBooks Data", "select timemodified#(lf)from creditmemoline")" to pull all columns from this table (creditmemoline) for only transactions posted from 1/1/2016 through 6/30/2017?
Thank you for your consideration, Sally

 

[pbornemeier]

Can't be sure, but probably replace:
"= Odbc.Query("dsn=QuickBooks Data", "select timemodified#(lf)from creditmemoline")"
with
"= Odbc.Query("dsn=QuickBooks Data", "select timemodified#(lf)from creditmemoline(lf)where timemodified# >= {d '2016-01-01'} AND timemodified# <= {d '2017-06-30'}")"

Unfortunately there can be multiple date formats and I am not sure which one will work on your instance