Forum Discussion
Filter rows where difference between dates is lower than 31 days
Hello, have a dataset where I want to filter out (or combine) rows when the difference between the enddate of this row and the startdate of another row is lower than 31 days. The dataset look...
Hi nielsvanbruggen,
"filter out (or combine) rows when the difference between the enddate of this row and the startdate of another row is lower than 31 days."
What does startdate of another row mean? How do determine which startdate is used to compare with enddate in current row?
What is your desired output? Do you want a new table which has been filtered? Or do you want to add a new calculated column in source table?
Please provide more description about [StartDate(What I want)] and [Enddate(what I want)]. I don't understand how to get values like this.
Best regards,
Yuliana Gu