cancel
Showing results for
Did you mean:
Member

## I need help with my formula TODAY()

I thought this one was easy but guess not

i have a colume with a dates in it and i want to know how many times TODAY() is used.

COUNTROWS(Verzuimverloop[datum ziektemelding]=TODAY())

Simply put i want to know how many people called in sick today, therefore i used TODAY() because obviously i want to know the exact same thing tomorrow and i dont want to change the date each and every time

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User

## Re: I need help with my formula TODAY()

@RvdHeijden

Hi,

try using this measure:

CallsToday = COUNTROWS(FILTER(Verzuimverloop,Verzuimverloop[datum ziektemelding]=TODAY()))

Let me know if works on your side.

Lima - Peru

Proud to be a Datanaut!

3 REPLIES 3
Highlighted
Super User

## Re: I need help with my formula TODAY()

@RvdHeijden

Hi,

try using this measure:

CallsToday = COUNTROWS(FILTER(Verzuimverloop,Verzuimverloop[datum ziektemelding]=TODAY()))

Let me know if works on your side.

Lima - Peru

Proud to be a Datanaut!

Super Contributor

## Re: I need help with my formula TODAY()

Hi @RvdHeijden,

Have you tried the solution provided above? It should work in your scenario. If you still have any question, feel free to post it here.

Regards

Member

## Re: I need help with my formula TODAY()

Thanks for the reminder, i have a few posts on this forum and forgot to close this one.

That formula did the trick