Weekend dates

[Joey Martin]

I have a sql database and ASP pages.

How do I find out the DATES of THIS WEEKEND (fri-sun).

If today is Tuesday, I want to show information posted for THIS WEEKEND.

My table has a field called THEDATE which is what we need to search and
in the format MM/DD/YYYY.

Thanks!

 

[Bob Barrows [MVP]]

I have a sql database and ASP pages.

How do I find out the DATES of THIS WEEKEND (fri-sun).

If today is Tuesday, I want to show information posted for THIS
WEEKEND.

My table has a field called THEDATE which is what we need to search
and in the format MM/DD/YYYY.

Thanks!

What is the datatype of THEDATE? if it's a datetime field, then the
format is irrelevant.
If it's datetime, are you storing time as well as date in the field ?