Hello All

I want to take any records in my database that are no older than 2 weeks and display them. I tried this

SQLStr="SELECT * FROM ABNNews WHERE (date = " & (date-14) & ") ORDER by Date DESC"

If you can help me with this that would be great.

Thanks

__________________
-----------------------------------------------------------
\"Don\'t follow someone who\'s not going anywhere\" John Mason

Look into the DateAdd function.

Okay, I will see what I can do

Thanks

Not sure what database you are using, but try this.

MsSql:
SQLStr="SELECT * FROM ABNNews WHERE date >= '" & date()-14 & "' ORDER by Date DESC"

MsAccess:
SQLStr="SELECT * FROM ABNNews WHERE date >= #" & date()-14 & "# ORDER by Date DESC"

DaveGerard should be promoted. The project deadline was building a noose around my neck. Thanks a zillion Dave!


Cheers!
Pramod

"In this life, unless we don't live again"