Date question

[Matt]

I have a form field area that I need to always have display the
upcoming thursday date. ie. this week I would need the form field
area to display 3/1/2007. Then beginning on the Friday 3/2/07 i need
it start displaying 3/8/2007. any suggestions..

[Evertjan.]

Matt wrote on 24 feb 2007 in microsoft.public.inetserver.asp.general:

I have a form field area that I need to always have display the
upcoming thursday date. ie. this week I would need the form field
area to display 3/1/2007. Then beginning on the Friday 3/2/07 i need
it start displaying 3/8/2007. any suggestions..

Form fields are for client input, methinks,
so what you "need" could not be what you want.

vbscript:

theDate = Date()
n = 5 - weekday(theDate)
if n<0 then n = n + 7
nextThursday = dateAdd("d",n,theDate)

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

[Dave Anderson]

"Matt" wrote:

I have a form field area that I need to always have display
the upcoming thursday date. ie. this week I would need the
form field area to display 3/1/2007. Then beginning on the
Friday 3/2/07 i need it start displaying 3/8/2007.

Then you would probably be interested in the Weekday Function:
http://msdn.microsoft.com/library/en...09a72491bd.asp

Here's a VBScript function that will produce the requested "next thursday":

Function NextThursday(d)
NextThursday = DateAdd("d",7-Weekday(d,6),d)
End Function

--
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.

[Bob Lehmann]

This could probably be refined more, but for SQL Server, and first day of
week set to Sunday -

declare @day_of_week int
declare @days_left_in_week int
declare @cut_off int
declare @next_day int

select @day_of_week = DATEPART(dw, GETDATE())
select @days_left_in_week = 7 - @day_of_week
select @cut_off = 6 -- Friday
select @next_day = 5 -- Thursday

if @day_of_week >= @cut_off
begin
select getdate() + @next_day + @days_left_in_week
end
else
begin
select getdate() + @next_day - @day_of_week
end
-- end if

Bob Lehmann

"Matt" <mw******@caldrywall.comwrote in message
news:11**********************@p10g2000cwp.googlegr oups.com...

I have a form field area that I need to always have display the
upcoming thursday date. ie. this week I would need the form field
area to display 3/1/2007. Then beginning on the Friday 3/2/07 i need
it start displaying 3/8/2007. any suggestions..