Forum Discussion
Date is NOT within previous N months
DataFormat.Error - The dates were for USA (mdy) format. I think your date format is different is dmy, that is why this error as there is no 21 month. However, let's forget this.
Right syntax is
each not Date.IsInPreviousNYears([DATE COLUMN], 2))
Note that Date.IsInPreviousNYears excludes current year. So if current year is 2022, it will exclude only 2021 and 2020. But will include 2019, 2018 and ALSO 2022. And also if future year dates are there, they will be included.
perfect, thank you very much
one last question if i may?
What is the correct syntax to identify dates that are eaxctly 2 years prior to todays date ?
Im assuming to make it dynamic you use the DateTime.LocalNow()) syntax but how can i use the date filters to extract only the date exactly 2 years from today
See this for 2 years before date
Date.AddYears(Date.From(DateTime.FixedLocalNow()),-2)
Hence
each [DATE COLUMN] = Date.AddYears(Date.From(DateTime.FixedLocalNow()),-2)
Firstly your code provided generates the follwoing error DataFormat.Error: We couldn't parse the input provided as a Date value.
Details:
6/21/2022
However this doesnt answer my question. I need to know how to filter if the date is NOT in the previous 2 years
for example code supplied is
each Date.IsInPreviousNYears([DATE COLUMN], 2))
I want it look soemthing like this
each Date.Is NOT InPreviousNYears([DATE COLUMN], 2))
- Vijay_A_Verma
Most Valuable Professional
DataFormat.Error - The dates were for USA (mdy) format. I think your date format is different is dmy, that is why this error as there is no 21 month. However, let's forget this.
Right syntax is
each not Date.IsInPreviousNYears([DATE COLUMN], 2))
Note that Date.IsInPreviousNYears excludes current year. So if current year is 2022, it will exclude only 2021 and 2020. But will include 2019, 2018 and ALSO 2022. And also if future year dates are there, they will be included.
perfect, thank you very much
one last question if i may?
What is the correct syntax to identify dates that are eaxctly 2 years prior to todays date ?
Im assuming to make it dynamic you use the DateTime.LocalNow()) syntax but how can i use the date filters to extract only the date exactly 2 years from today
- Vijay_A_Verma
See this for 2 years before date
Date.AddYears(Date.From(DateTime.FixedLocalNow()),-2)
Hence
each [DATE COLUMN] = Date.AddYears(Date.From(DateTime.FixedLocalNow()),-2)