Solved: How to compare 2 dates by MONTH+YEAR - Page 2

antimixer · 03-18-2022 03:14 PM

Why I cant to write so to compare 2 values? Expression result here is YES/NO I think:

MONTH(orders[order_date]) & YEAR(orders[order_date]) = MONTH(TODAY()) & YEAR(TODAY())

but it is right: MONTH(TODAY())&YEAR(TODAY()) = 32022

Joseph_Seddik

For matching:

AND(
MONTH([order_date]) = MONTH(TODAY),
YEAR([order_date]) = YEAR(TODAY)
)

For calculating the number of months between two dates:

MONTH([date2]) - MONTH([date1]) +
IF( YEAR([date2]) = YEAR([date1]),
0,
12 * (YEAR([date2]) - YEAR([date1])
)