Row Filtering by date

[Tim_Martin]

I’m trying to filter rows by date, specifically using the current Month & Year MONTH([DATE])+year([date])=Month(now())+year(now()), but this doesn’t seem to be working correctly.

While it does pull this current month’s data, it is also pulling December 2018. When looking at the ‘test’ data, I cannot deduce why it is pulling information from 5 entries in during the December '18 timeframe. Any ideas??

[Bellave_Jayaram · Accepted solution]

This is not correct -
MONTH([DATE])+year([date])=Month(now())+year(now())

Change it to AND(MONTH([DATE])=Month(now()), YEAR([DATE])=year(now()))

[Tim_Martin]

That’s perfect!!! Thanks @Bellave_Jayaram!
(to be honest, I was kinda winging it by adding on the + year([date])… but I knew someone would set me straight!)

[Bellave_Jayaram]

You are welcome

[Aleksi]

Another way is EOMONTH(TODAY())=EOMONTH([Date]).