Forum Discussion
How do I check if a date has passed using Power Query?
I am trying to check if a date has passed and remove that row from my data. I've created a column and attempted to use the Date.IsInPreviousNYears function but it is yielding a "True" for everything....
Yes, you need to pass the field as a parameter. The function already knows the current date so just something simple:
Date.IsInPreviousNYears([ExpirationDate], 5)
Thanks for the help! When I added it to my Custom Column, I recieved an error on every line. When I went into the settings for the Custom Column (where this equation lives), it updated it to Date.IsInPreviousNYears(Date.AddYears([ExpirationDate]), 5). Is this right?