Re: Comparing two date fields

From: "Rick Brandt" <rickbrandt2@xxxxxxxxxxx>
Date: Fri, 30 Mar 2007 14:31:46 GMT

nikit.kothari@xxxxxxxxx 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

.

Follow-Ups:
- Re: Comparing two date fields
  - From: Tom van Stiphout

References:
- Comparing two date fields
  - From: nikit . kothari

Prev by Date: Comparing two date fields
Next by Date: Re: How to search for a question-mark in an open table with CTRL-F?
Previous by thread: Comparing two date fields
Next by thread: Re: Comparing two date fields
Index(es):
- Date
- Thread

Relevant Pages

Re: Trouble with security in Access 2003 DB after computer dies
... I don't see anything wrong with the target. ... What error message do you get? ... Joan Wild ... Microsoft Access MVP ...
(microsoft.public.access.security)
Re: No logon at other workstations
... As well, you're missing ... Doug Steele, Microsoft Access MVP ... :> And I get an error that the target cannot be found. ... :>> Joan Wild ...
(microsoft.public.access.security)
Re: Admin/owner of the db is receiving permission message
... Create a desktop shortcut with the following in the target: ... Joan Wild ... Microsoft Access MVP ...
(microsoft.public.access.security)
Re: Access Runtime Error when using Str function
... on the target PC. ... Your program indicates that all the reference likes ... RBrandt at Hunter dot com ...
(microsoft.public.access.setupconfig)
Re: DateAdd Function
... Rick Brandt, Microsoft Access MVP ... RBrandt at Hunter dot com ...
(microsoft.public.access.forms)