Access DateAdd help (please)

Associate
Joined
27 Nov 2003
Posts
2,481
Location
Loughborough
I have some purchase data which has a due date field and I want to return anything that is due in three months plus, however using >=Month(DateAdd("m",3,Date())) it refuses to pick up anything outside of 2018

What am I doing wrong? I have nothing in the query except Product, Due Date and this calculation. Without the calculation I can see dates in 2019...

This one baffles me, help :)
 
Back
Top Bottom