Complex query (or at least i think so)

Databases
1

Guys,

Given this data:

DATE 1
05/08/2010
06/08/2010
03/08/2010

I want to pull out the rows that are >= to 14 days Between DATE 1 and CurrDate(). How do i do this?

thanks

2

that depends entirely on the database system you happen to be using, which you neglected to mention

my guess is, it’s not mysql

:cool:

3

Take a look at http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-add

4

I think you are using MSSQL, if so it would be something like the following

DATEDIFF(‘d’, ‘05/08/2010’, getdate()) >= 14

in MySQL I think its slightly different

DATEDIFF(NOW(),‘2010/08/05’) >= 14