• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 555
  • Last Modified:

Query to find out if Last_Update is less than three months from 8/10/2012.

I need a query to find out if Last_Update is less than three months from 8/10/2012.
Thank you.
0
donnie91910
Asked:
donnie91910
  • 2
2 Solutions
 
Dale FyeCommented:
in which direction?

SELECT * from yourTable WHERE [Last_Update] <= DateAdd("m", 3, #8/12/12)
0
 
hnasrCommented:
SELECT * from tbl WHERE [Last_Update] < DateAdd("m", -3, #08/12/2012# )
0
 
YZlatCommented:
fyed, it will be more than 3 month. You nedd to use -3 and not 3
0
 
Dale FyeCommented:
Well, that actually depends on what the OP means by "less than three months from 8/10/2012"

It could mean > #5/10/12#, < #5/10/12#, or maybe < #11/10/12#,
but most likely not > #11/10/12#
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now