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())
)
I think you need to read the documentation. The problem is readily evident.
User | Count |
---|---|
40 | |
29 | |
24 | |
24 | |
13 |