Comparing two date fields

[nikit.kothari]

I have two date fields, actual and target.

i would like to return all data from the table only if the actual date
is within 30 days after the targeted date.

[Rick Brandt]

ni***********@gmail.com wrote:

I have two date fields, actual and target.

i would like to return all data from the table only if the actual date
is within 30 days after the targeted date.

SELECT *
FROM TableName
WHERE Abs(DateDiff("d", actual, target)) < 31

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Tom van Stiphout]

On Fri, 30 Mar 2007 14:31:46 GMT, "Rick Brandt"
<ri*********@hotmail.comwrote:

You could drop the "Abs" part if you were serious about "after"
-Tom.

>ni***********@gmail.com wrote:

>I have two date fields, actual and target.

i would like to return all data from the table only if the actual date
is within 30 days after the targeted date.

SELECT *
FROM TableName
WHERE Abs(DateDiff("d", actual, target)) < 31