Forum Discussion
Solved
How to display dates without todays date?
Hello,
I have a calendar table wheres date, year, month, day and I want a column that shows what days are past = 0 and todays day = 1.
I have this formulas:
1) IsCurrentDay = IF(AND(DAY(Kalender[Datum])=DAY(TODAY()), MONTH(Kalender[Datum])=MONTH(NOW())),1,0)
This formula shows date for ex. 10.1.2023 as 1, for other years with same date but another year also marked as 1.
2) IsCurrentDay = IF(AND(DAY(Kalender[Datum])=DAY(TODAY()), YEAR(Kalender[Datum])=YEAR(NOW())),1,0)
This formula shows date for ex. 10.1.2023 and 10.2.2023 as 1. But I want just date 10.2.2023 to be marked as 1.
I tried this one:
IsCurrentDay = IF(AND(DAY(Kalender[Datum])=DAY(TODAY()), MONTH(Kalender[Datum])=MONTH(NOW()), YEAR(Kalender[Datum])=YEAR(NOW())),1,0)
but function AND allows only 2 arguments.
Is there any other options? Thank you
You can add a column like
Is Current Day = IF ( Kalender[Datum] = TODAY (), 1, 0 )
