Forum Discussion
How to filter out same day with 2 datetime coumn
Hello,
My dataset has 2 datetime column like this, I would like to create a new column shows how long it take from Cart to when the sale is completed. I want to filter out that the date in Sales Order Date is the same day with Cart Created On because there is some row that are in different days. I need to calculate the difference time between these 2 columns with the filter is the same day.
Sorry for my English if it's not clear.
Thanks a lot
Add a column to get your duration by subtracting the times
Then click the arrow next to your new column > duration filters > greater than and enter 1 (for 1 days) which will remove all of your same day data.
2 Replies
Add a column to get your duration by subtracting the times
Then click the arrow next to your new column > duration filters > greater than and enter 1 (for 1 days) which will remove all of your same day data.