DATE!!

  • Thread starter Thread starter Nick Read
  • Start date Start date
N

Nick Read

****PLEASE HELP******

I am trying to create a query that only selects data from
a database where the date (I have date column in the
database) is less than or equal to today's date minus six
month.

Thanks

Nick
 
The SQL String should be something like:

SELECT *
FROM YourTable
WHERE YourDateField <= DateAdd("m", -6, Date())
 
Back
Top