Dates

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hi,

Thank you for all help that I have received I have managed
some issues, but one remains! I cannot get this one right:
I have 2 field dates: [Date of reply] and [Date of close
out]. I want a blank return in the [Date of close out]
field, so I have entered Is Null as a criteria in this
field, and that works fine. The second condition is that I
only want these returns if the dates entered in the [Date
of reply] field are older than 14 days. I have entered the
following statement:
[Results of investigation].[Date of reply]+14>Date()

It brings me back even dates that are less than 14 days
old which I don't want. Is there a way to solve this
problem?

Many thanks,
Chris.
 
Hi,

Thank you for all help that I have received I have managed
some issues, but one remains! I cannot get this one right:
I have 2 field dates: [Date of reply] and [Date of close
out]. I want a blank return in the [Date of close out]
field, so I have entered Is Null as a criteria in this
field, and that works fine. The second condition is that I
only want these returns if the dates entered in the [Date
of reply] field are older than 14 days. I have entered the
following statement:
[Results of investigation].[Date of reply]+14>Date()
Click to expand...

I'd suggest putting a criterion on the Criteria line in the query grid
under [Date Of Reply] of

< Date() - 14

This will calculate a date 14 days old (ignoring any holidays or
weekends, just calendar days), and return those records where [Date of
reply] is less (earlier) than that date.
 
Back
Top