ODBC Date prefilter for Power Query

[hnrbsd]

Hi,

I am working on a power query report, based on QAD erp data tables using ODBC connection. I am using filters already on the source to optimise load time (mainly date, domain etc.).

Here is an example:
SELECT op_date,op_qty_comp,op__dec01,op_emp FROM PUB.op_hist WHERE op_date > '01-01-2021' WITH (NOLOCK)

This is working great, but my goal would be to change this date from the excel table itself before updating the file. I have no ideea how could I use the excel date as a reference on the data surce.

I would be thankful for any help.

Thanks.