Power Query Date Range - Between Two Dates

[jws]

Hello,

I am having trouble with logic on this on a function where I am trying to create a rolling history file with a rolling date range.

Basically I am taking today's date and my goal is:
1) Pull data 60 days ago (which works) - but where my problem is, I am trying to add an "AND" statement that limits to Today - 40 days)

This works
= Table.SelectRows(#"Changed Type", each [DATE] > Date.AddDays(Date.From(DateTime.LocalNow()),-60))

Today is June 1st (return data from 4/2/20 thru 4/22/20)

4/2/20 = (-60 days from today)
4/22/20 = (-40 days from today)

I don't want to use actual dates since this will be a rolling file. If this is unclear let me know, thanks for reading.

 

[John_w]

Try:

= Table.SelectRows(#"Changed Type", each ([DATE] >= Date.AddDays(DateTime.Date(DateTime.LocalNow()),-60) and [DATE] <= Date.AddDays(DateTime.Date(DateTime.LocalNow()),-40)))

 

[jws]

Try:

= Table.SelectRows(#"Changed Type", each ([DATE] >= Date.AddDays(DateTime.Date(DateTime.LocalNow()),-60) and [DATE] <= Date.AddDays(DateTime.Date(DateTime.LocalNow()),-40)))

Thank you