Formula is corret but giving wrong results

My intension is to get the results for the current month, but as you see in the picture I am getting three results but 2 are from current month and one is next month

Your expression is bad.

See also:

Hello Steve,

Many thanks for your reply

Would you be able to elebroate a little bit more

Chetan

Try this;

AND (
YEAR([DUE DATE]=
YEAR(TODAY()),
MONTH([DUE DATE])=
MONTH(TODAY())
)

1 Like

I think you need to read the documentation. The problem is readily evident.

2 Likes