Dates

[echo0001]

I need to run a query that will return all records for a due date within 30 days from the computers date

this is the code i have so far.

SELECT NRTS.Item, NRTS.Description, NRTS.[NRTS No], NRTS.[Serial Number], NRTS.[Cal Due], NRTS.[Allocated To]
FROM NRTS
WHERE [Cal Due]


thank you for your time.

 

[pbaldy]

WHERE [Cal Due] < DateAdd("d", 30, Date())

 

[georgedwilkinson]

SELECT NRTS.Item, NRTS.Description, NRTS.[NRTS No], NRTS.[Serial Number], NRTS.[Cal Due], NRTS.[Allocated To]
FROM NRTS
WHERE [Cal Due] 
BETWEEN Date() - 30 AND Date() + 30;

is one way.

 

[echo0001]

Thanks that has solved it