Row filter condition in slice by date, greater/lesser than

The date format is 30.07.2020 (day.month.year)

Here is what I’m trying to do, but I fail miserably. I’ve tried everything I could find on the subject.

[Start Date] should be newer than today. (Aka, In the future)
[END Date] should be older than today (Aka, In the past)

In generally the formula should be like AND([Start Date]>TODAY(),[End Date]<TODAY()), but I’m assuming that the Start Date is smaller than End Date. If that the case, there is no formula that could give you a result as TRUE.

2 Likes

Yes, that whas the results I got when I tried that. A blank page. They worked seperately when I tried. But not together.

I’m trying to filter out contracts that has not started yet and contracts that has ended, so the user doesn’t see these rows. Any thoughts on a workaround?

EDIT: It was just a simple OR statement that was needed. Hashtag: Know when to take a break…

AND(
[Tjeneste]<>“Matteleie”,
[Tjeneste]<>“Skadedyr-avt.”,
OR(
[Start Date]<TODAY(),
[End Date]>TODAY()
)
)

4 Likes

Excellent!

1 Like

Just tested some more.

This is a really expensive formula. Look at the values in the middle. Before and after is without this formula.

image

I don’t get it

Why wouldn’t this work ? :

AND(
[Tjeneste]<>“Matteleie”,
[Tjeneste]<>“Skadedyr-avt.”,
[Start Date]<TODAY(),
[End Date]>TODAY()
)

I think that “OR” will also give you contracts that started and ended in the past

Not sure why. I ended up with using apps script instead, adding “1” to a column if I want that row to hide.