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!
*** Sent via Developersdex http://www.developersdex.com ***
Joey Martin wrote:
> 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 ?
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
"Joey Martin" wrote:
> 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.
What does "this weekend" mean? The coming weekend? Specifically, when does
it transition to the next one? On Saturday? On Monday?
Also, do you want to compute this in the database or in your web script? In
either case, what is the environment (ASP: JScript/VBScript, database: SQL
Server/Oracle/MySQL/MS Access)?
--
Dave Anderson
Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms.