This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Formula is corret but giving wrong results

Posted on 02-22-2021 09:48 AM
Landlord_Buddy
New Member
Reply posted on --/--/---- --:-- AM

3X_6_5_650de3dfb3cce1c226bc0f8d85aa6b6a7a006d49.png

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

0 4 158
Topic Labels
0 Likes
4 REPLIES 4

Posted on --/--/---- --:-- AM
Steve
Platinum 4
Platinum 4
Reply posted on --/--/---- --:-- AM

Your expression is bad.

See also:

0 Likes

Posted on --/--/---- --:-- AM
Landlord_Buddy
New Member
In response to Steve
Reply posted on --/--/---- --:-- AM

Hello Steve,

Many thanks for your reply

Would you be able to elebroate a little bit more

Chetan

0 Likes

Posted on --/--/---- --:-- AM
HBT
Silver 4
Silver 4
In response to Landlord_Buddy
Reply posted on --/--/---- --:-- AM

Try this;

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

Posted on --/--/---- --:-- AM
Steve
Platinum 4
Platinum 4
In response to Landlord_Buddy
Reply posted on --/--/---- --:-- AM

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

Top Labels in this Space