Simple ASP script isn't working...

OneDayAgo = now()-1

sql = "SELECT * FROM Content WHERE publishDate <'"&OneDayAgo&"' ORDER BY PublishDate ASC"
set rs = objConn.execute(SQL)

Why does this not return articles published in the last 24hrs?

I either get everything or nothing depending on the direction the < is pointing.

publishdate is just a standard datetime db column...

Hi,

Not very sure but should < not be =

Apologies if i am thinking wrongly.

Regards

hmm, not sure - would that not return only exact matches? (ie posts made exactly the same second as 24hrs ago)

Ya agree,
it could be the case, am not able to check out at my end for lack of such data;

don't know whether something like this

where Date between '" & DateFrom & "' and '" & DateTo & "'

can be helpful.

Let us wait for a while, the gurus will come by

Regards

What exactly do you want here??

Your query will get all records for which publishDate is less than yesterday and NOT last 24 hours records.

If you want last 24 hours records then you'll something like new learner is suggesting.

Hi Micky,

So by that logic would this not get the last 24 hrs?

sql = "SELECT * FROM Content WHERE publishDate >'"&OneDayAgo&"' ORDER BY PublishDate ASC"

No, it will show whose records whose date is greater than yesterday.

If you have records in database whose date is bigger than today or may be week later...... then you'll get all those records.

what is your database? Access? SQL Server?

Hi shadow - sql server 2000

I think SQLServer has native commands for adding dates so you could try something liek this:

Have tested this - works perfectly! Thanks very much sync or swim!

Hi Sync,
Just for my info

If instead of

sql = "SELECT * FROM Content WHERE publishDate >= DateAdd(day, -1, getDate()) ORDER BY PublishDate ASC"

I have

sql = "SELECT * FROM Content WHERE publishDate >= DateAdd(h, -24, getDate()) ORDER BY PublishDate ASC"

what kind of output can be expected or is it not possible.

Thanks

it's the same thing, one day is 24 hours.
it's like the difference between:

and:

Thanks shadow;
I was just wondering whether in the case of
(day,-1,GetDate())
will the output be all data corresponding to the previous day's date
&
in case of
(h,-24,GetDate())
will the output be all data corresponding to the 24 hrs from the current date & time.

Thanks

it will be the same data, because those two things are the same, they're
simply two ways to write the same thing.