query to return records where a date field is between now and 3 montsh in the future

select *
from table
where [datefield] between Date() and Dateadd("m",3,Date())

or this one

select *
from table
where [datefield] between dateserial(Year(Date()),month(date()), day(date()) and dateserial(Year(Date()),month(date())+3, day(date())

All

Have tried all the above but can't seem to get them to work - keeps saying data type mismatch

this however works...

SELECT EmployeeData.[Employee ID], EmployeeData.[Termination Date]
FROM EmployeeData
WHERE (((EmployeeData.[Termination Date])<Now()+90));
 
but would prefer to be able to add 3 months instead of 90 days if possible

Data in field is set as Date/Time so unsure why a data mismatch

any ideas

Shaz

try this, copy and paste


SELECT EmployeeData.[Employee ID], EmployeeData.[Termination Date]
FROM EmployeeData
WHERE EmployeeData.[Termination Date] between dateserial(Year(Date()),month(date()), day(date()) and dateserial(Year(Date()),month(date())+3, day(date())

Thank you all

finally got it

rgds

shaz