Get dates 14 days and over

  • Thread starter Thread starter Alex Martinez
  • Start date Start date
A

Alex Martinez

Hi,

I am using Access 2002 and I have a date field called Assignment date and I
want to get all assignments 14 days passed and over. How do I do that? Any
tips will be appreciate. Thank you.
 
SELECT * FROM tblMyTable
WHERE [Assignment Date]+14 >=Date()

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
I have a different interpretation so if Graham's suggestion is not what you
want, try:

SELECT * FROM tblMyTable
WHERE [Assignment Date] <= DateAdd("d", -14, Date())
 
Graham, Van - I appreciate the help. Thanks for responding. Good day.

Regards,


Van T. Dinh said:
I have a different interpretation so if Graham's suggestion is not what
you
want, try:

SELECT * FROM tblMyTable
WHERE [Assignment Date] <= DateAdd("d", -14, Date())

--
HTH
Van T. Dinh
MVP (Access)



Alex Martinez said:
Hi,

I am using Access 2002 and I have a date field called Assignment date and I
want to get all assignments 14 days passed and over. How do I do that? Any
tips will be appreciate. Thank you.
Click to expand...
Click to expand...
 
Back
Top