Solved: Disregard year when filtering dates in slice - Page 2

Ratatosk · 03-26-2021 01:48 AM

The below code works for filtering a slice, but I’d like to disregard the year in the formula so it can be set up as a recurring event each year.

Am I going about this all wrong? Any ideas on what I can do or if it is even possible to do that with dates?

AND([Tjeneste]=“Vaktmester”, or(and(Isblank([PauseToDate]), isblank([PauseFromDate])),and(Date([PauseToDate])<Date(Today()),Date([PauseFromDate])>Date(Today()))))

Ratatosk

I think I got it now. Tests work out so far.

Now I can hide rows that are within a range of dates with slices. (So they only show when today() is not within that range)

AND([Tjeneste]="Vaktmester", OR(
 
AND(ISBLANK([PauseToDate]), ISBLANK([PauseFromDate])), 

AND(NUMBER(TEXT([PauseToDate], "MMDD"))>NUMBER(TEXT(TODAY(), "MMDD")),
NUMBER(TEXT([PauseFromDate], "MMDD"))>NUMBER(TEXT(TODAY(), "MMDD"))),

AND(NUMBER(TEXT([PauseToDate], "MMDD"))<NUMBER(TEXT(TODAY(), "MMDD")),
NUMBER(TEXT([PauseFromDate], "MMDD"))<NUMBER(TEXT(TODAY(), "MMDD")))
)
)

View solution in original post