Criteria for dates within 2 weeks of shipdate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to query for all records that are within 2 weeks of set [Ship Date].
This expression isn't working in criteria.

Date()<=([Ship Date]-14)

Is this right? Please help. Thanks from a neophite.
 
I want to query for all records that are within 2 weeks of set [Ship
Date].
Your statement says you want all records starting 2 weeks before the
shipping date through 2 weeks after the shipping date. If this is what you
want then use this --
Between [Ship Date]-14 And [Ship Date]+14
 
Karl:

Sorry I wasn't clear in my statement. All records have a scheduled
shipdate. I am trying to query a two week notice, or ship dates within 2
weeks of today.

Thanks so much.

KARL DEWEY said:
I want to query for all records that are within 2 weeks of set [Ship
Click to expand...
Date].
Your statement says you want all records starting 2 weeks before the
shipping date through 2 weeks after the shipping date. If this is what you
want then use this --
Between [Ship Date]-14 And [Ship Date]+14


yuta10 said:
I want to query for all records that are within 2 weeks of set [Ship Date].
This expression isn't working in criteria.

Date()<=([Ship Date]-14)

Is this right? Please help. Thanks from a neophite.
Click to expand...
Click to expand...
 
Hi yuta10,

the date 2 weeks from today

Date() + 14

if [ShipDate] has time values,
to return only records w/ ShipDate
of 2 weeks from today

WHERE
[ShipDate] >= Date() + 14
AND
[ShipDate] < Date() +15

your word "within" may mean
above is not what you wanted?

if you want all records whose
ShipDate is "within" a range defined
as between today and 2 weeks from today
(and they contain time values)

WHERE
[ShipDate] >= Date()
AND
[ShipDate] < Date() +15


Apologies if misunderstood,

gary

yuta10 said:
Karl:

Sorry I wasn't clear in my statement. All records have a scheduled
shipdate. I am trying to query a two week notice, or ship dates within 2
weeks of today.

Thanks so much.

KARL DEWEY said:
I want to query for all records that are within 2 weeks of set [Ship
Click to expand...
Date].
Your statement says you want all records starting 2 weeks before the
shipping date through 2 weeks after the shipping date. If this is what
you
want then use this --
Between [Ship Date]-14 And [Ship Date]+14


yuta10 said:
I want to query for all records that are within 2 weeks of set [Ship Date].
This expression isn't working in criteria.

Date()<=([Ship Date]-14)

Is this right? Please help. Thanks from a neophite.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top