How to make a filter on date dynamic based on a specific start date and a dynamic yesterday

[attaalla]

hello, community,

i am stuck in how to change the filter on date column in power query to a dynamic end point.
i connected my source to a website  & i want my report to bring data based on a specific start point & a dynamic yesterday based on local time.

for more simplification:

= Table.SelectRows(#"Reordered Columns", each [Date] >= #date(2023, 1, 1) and [Date] <= #date(2023, 2, 28))

i want to change [Date] <= #date(2023, 2, 28) to a dynamic end point refers to yesterday based on my local time.

thanks in advance

[attaalla]

@FreemanZ 

your support is highly appreciated.
 it worked fine now

[FreemanZ]

hi @attaalla 

try like:

[Date] <= Date.AddDays(DateTime.LocalNow (),-1)

[attaalla]

@FreemanZ 
thanks for reaching out.
however, there is an issue with the time formating i think.

[FreemanZ · Accepted solution]

hi @attaalla 

try like:

[Date] <= Date.AddDays(DateTime.Date(DateTime.LocalNow ()),-1)