Dynamic value in #datatime (QueryFilter)

[MWD]

Hello,

Could anyone help me to fix an issue how to set query in order to get records between specific date time range? I need to change range dynamically:

start of range: (currentYear, currentMonth, currentDay - 1, 6,0,0) 

end of range:(currentYear, currentMonth, currentDay, 6,0,0) 

At pic is only end filteration range. How is it possible to modify this query in orrder I could use dynamic variables in query?

I tried this but it didn't work:

= Table.SelectRows(#"Renamed Columns", each [Created] <= #datetime(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()),6,0,0)) 

 RB,

MWD

[v-chuncz-msft · Accepted solution]

@MWD,

You may refer to the code below.

    #"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each [Created] > DateTime.From(DateTime.Date(DateTime.LocalNow())) + #duration(-1,6,0,0) and [Created] <= DateTime.From(DateTime.Date(DateTime.LocalNow())) + #duration(0,6,0,0))