Power Query 中,PostgreSQL ,实现日期参数传递功能筛选数据源
现有代码,参数为文本型的,两个参数,分别是开始日期 FirstDayYear和结束日期LastDay,代码调试OK
"Select sm.shopid, sum(td.amount * td.saletype), min(td.saledate), max(td.saledate)
from sc_eka.ticketdetail td, sc_eka.oldshopsmapping sm
where sm.oldshopid = td.shopcode
and td.saledate >= date '" & FirstDay &"'
and td.saledate >= sm.opened + interval '1 years'
and td.saledate <= date '" & LastDay & "'
and td.shopcode < 3000
and td.shopcode <> 1157
group by sm.shopid", null, [EnableFolding=true])
想把两个文本参数FirstDayYear和结束日期LastDay 更改成日期参数,代码调试多次,都显示错误?and td.saledate <= to_char '" & LastDay & "'
更换参数类型的目的,想在PowerBI 保持一致的参数类型。
如何正确调用参数在PostgreSQL 环境中