Format daty Power pivot sprzedaż promocje zakres dat

[czarny]

Chce napisać zapytanie które umożliwi mi pobranie danych po przez power pivot

,trn_data3 = (cdn.data(2021,6,21))

select 1 as lp,cdn.NazwaObiektu(TrE_GIDTyp,TrE_GIDNumer,0,2) as Dokument,TrE_Pozycja as Poz,TrE_TwrKod as Kod,
cast(pd.podstawa as decimal(15,2)) as Podstawa,
cast(pd.doplata as decimal(15,2)) as Dopłata,
cast(TrE_Ilosc as int) as Ilosc,
cast(TrE_Ilosc*pd.podstawa as decimal(15,2)) as [suma Podstawa],
cast(TrE_Ilosc*pd.doplata as decimal(15,2)) as [suma Dopłata],
p.PRM_Akronim
from
dbo.ITEGER_PromocjeDokumenty pd
join cdn.TraElem on TrE_GIDNumer = dok_numer and TrE_GIDTyp = dok_typ and TrE_GIDLp = dok_lp
join cdn.TraNag on TrE_GIDNumer = TrN_GIDNumer and TrE_GIDTyp = TrN_GIDTyp
join cdn.PrmKarty p on p.PRM_Id = pd.prm_id
where TrN_Data2 between ??,trn_data3 = (cdn.data(2021,6,21)) and ??,trn_data3 = (cdn.data(2019,6,21))

Czy mogę prosić o pomoc ? interesuje mnie zmienianie dat od do
Oryginale zapytanie pobrane z wygląda tak. Zostało pobrane z zakładki denifycja wykresu konfiguracja wykresu.

@PAR ?@D17|DataOd|&DataOd:REG={DateClwFirstDay('m')} @? PAR@
@PAR ?@D17|DataDo|&DataDo:REG={DateClwLastDay('m')} @? PAR@

select 1 as lp,cdn.NazwaObiektu(TrE_GIDTyp,TrE_GIDNumer,0,2) as Dokument,TrE_Pozycja as Poz,TrE_TwrKod as Kod,
cast(pd.podstawa as decimal(15,2)) as Podstawa,
cast(pd.doplata as decimal(15,2)) as Dopłata,
cast(TrE_Ilosc as int) as Ilosc,
cast(TrE_Ilosc*pd.podstawa as decimal(15,2)) as [suma Podstawa],
cast(TrE_Ilosc*pd.doplata as decimal(15,2)) as [suma Dopłata],
p.PRM_Akronim
from
dbo.ITEGER_PromocjeDokumenty pd
join cdn.TraElem on TrE_GIDNumer = dok_numer and TrE_GIDTyp = dok_typ and TrE_GIDLp = dok_lp
join cdn.TraNag on TrE_GIDNumer = TrN_GIDNumer and TrE_GIDTyp = TrN_GIDTyp
join cdn.PrmKarty p on p.PRM_Id = pd.prm_id
where TrN_Data2 between ??DataOd and ??DataDo


,trn_data3 = (cdn.data(2019,2,1))

[praiser]

Zapytanie w SQL wystarczy tak:
(...)
where TrN_Data2 between (cdn.data(2021,6,21)) and (cdn.data(2019,6,21))

albo tak

declare @data_od int = (cdn.data(2021,6,1))
declare @data_do int = (cdn.data(2021,6,1))
(...)
where TrN_Data2 between @data_od and @data_do